Append a deal status update to a Google Sheets sales tracking spreadsheet.
Append a deal status update to a Google Sheets sales tracking spreadsheet.
Use this workflow when the user wants to log a deal status change, update a sales pipeline tracker, or record a customer interaction.
gws drive files list \
--params '{"q": "name contains 'SHEET_NAME' and mimeType = 'application/vnd.google-apps.spreadsheet'"}' \
--fields "files(id,name)" --format table
gws sheets +read --spreadsheet SHEET_ID --range "SHEET_TAB!A1:F" --format table
Show the user the current state of the pipeline.
Gather the update details from the user and append:
gws sheets +append --spreadsheet SHEET_ID --range 'SHEET_TAB' \
--values '["DATE", "COMPANY", "STATUS", "AMOUNT", "QUARTER", "OWNER"]'
Show the user the updated row.