Skip to main content

Google Sheets Integration

DriveMate lets you create, read, and modify Google Sheets spreadsheets directly from Salesforce - through Flows, Quick Actions, or Apex code.

Here's an overview of what you can do:

  1. Create spreadsheets with pre-defined sheets, headers, and data rows - all from a Flow or Apex trigger.
  2. Append rows to existing spreadsheets when new records are created in Salesforce.
  3. Edit rows by matching criteria - update specific cells when Salesforce data changes, while preserving formulas and manually entered values.
  4. Delete rows by matching criteria - remove spreadsheet rows when records are deleted in Salesforce.
  5. Use Google Sheets formulas in cell values - DriveMate passes formulas through to Google Sheets so they evaluate natively in the spreadsheet.
  6. Keep spreadsheets in sync with Salesforce data - combine the actions above into record-triggered Flows that mirror your Salesforce records in real time.

See Automations for a full reference of available actions and their parameters, follow the Sales Calculator example for a complete end-to-end walkthrough, or learn how to handle Complex Multi-Sheet Spreadsheets using the template-based approach.