Back to Details

recipe-log-deal-update

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Log Deal Update to Sheet

将成交状态更新记录到表格

PREREQUISITE: Load the following skills to execute this recipe: 
gws-sheets
, 
gws-drive
Append a deal status update to a Google Sheets sales tracking spreadsheet.
前提条件： 加载以下技能以执行此方案：
gws-sheets
、
gws-drive
将成交状态更新追加到Google Sheets销售跟踪电子表格中。

Steps

步骤

  1. Find the tracking sheet: 
    gws drive files list --params '{"q": "name = '\''Sales Pipeline'\'' and mimeType = '\''application/vnd.google-apps.spreadsheet'\''"}'
  2. Read current data: 
    gws sheets +read --spreadsheet-id SHEET_ID --range 'Pipeline!A1:F'
  3. Append new row: 
    gws sheets +append --spreadsheet-id SHEET_ID --range 'Pipeline' --values '["2024-03-15", "Acme Corp", "Proposal Sent", "$50,000", "Q2", "jdoe"]'
  1. 查找跟踪表格：
    gws drive files list --params '{"q": "name = '\''Sales Pipeline'\'' and mimeType = '\''application/vnd.google-apps.spreadsheet'\''"}'
  2. 读取当前数据：
    gws sheets +read --spreadsheet-id SHEET_ID --range 'Pipeline!A1:F'
  3. 追加新行：
    gws sheets +append --spreadsheet-id SHEET_ID --range 'Pipeline' --values '["2024-03-15", "Acme Corp", "Proposal Sent", "$50,000", "Q2", "jdoe"]'