Every morning at 7am
Daily copy of a Salesforce report in Sheets
Every morning the agent runs a saved Salesforce report and rewrites a sheet tab with its rows, so charts and formulas start from fresh data.
Salesforce + Google Sheets integration
Combine Salesforce + Google Sheets and move CRM data into your sheets, or sheet data into Salesforce. Just ask Letaido's AI agent and watch it do the work.
Best Salesforce and Google Sheets integration jobs to start with
Use this Salesforce Google Sheets integration for report copies, pipeline snapshots and lead imports.
Every Monday at 8am
Weekly Salesforce pipeline snapshot in Sheets
Every Monday the agent logs open Salesforce opportunities by stage and owner as dated rows in a sheet, so you can chart pipeline over time.
On the 1st of every month
Monthly revenue by lead source in Sheets
On the 1st of each month, add last month's won revenue and deal count per lead source to your sheet.
When you ask
Import a lead sheet into Salesforce
The agent creates a Salesforce lead for each new person in your sheet, skips people you already have, and writes the result next to each row.
When you ask
Add event attendees to a Salesforce campaign
Paste a sheet of event attendees and the agent adds the matching leads and contacts to your Salesforce campaign as Attended.
Salesforce Google Sheets integration options, compared
Most options pull reports into a sheet. Leta also checks each row it sends back.
| Option | Salesforce data into a sheet | Sheet rows into Salesforce | Runs on its own | Reasons over the data | Starts on a record change |
|---|---|---|---|---|---|
 Letaido AI agent | Yes | Yes | Yes | Yes | No |
| Data connector for Salesforce (Google add-on) | Yes | Yes | Partly | No | No |
| G-Connector by Xappex | Yes | Yes | Yes | No | No |
| Coefficient | Yes | Yes | Yes | Partly | No |
| Zapier, Make and similar | Yes | Yes | Yes | Partly | Yes |
Read the full comparison
| Option | Direction | What starts it | Best for | Watch out for |
|---|---|---|---|---|
| Letaido AI agent | Either way, one job at a time | A schedule, or when you ask | Jobs that need judgement: a daily report copy, a weekly pipeline snapshot, revenue by lead source, lead imports that skip people you already have | Not a live sync. Neither connector has an event trigger, so a record change can't start a job. Salesforce needs an edition with API access, and Google needs your own OAuth client |
| Data connector for Salesforce (Google add-on) | Both ways, from an add-on in Sheets | You, plus an optional refresh every 4, 8 or 24 hours for imported data | Pulling in a saved report or a SOQL query, and inserting, updating or deleting records from rows you highlight | Built by Google, with no charge to install. Changes go back to Salesforce only when you run them, and a delete removes the records you highlight |
| G-Connector by Xappex | Both ways | You, or its refresh schedule: hourly, daily or weekly | Scheduled report refreshes, bulk updates of thousands of records, and moving attachments between Salesforce and Google Drive | A separate add-on to install and manage. You set up each import and update yourself |
| Coefficient | Both ways | You, or its refresh schedule | Salesforce reports in Sheets refreshed on a schedule, data snapshots, and exports back to Salesforce | Automatic refresh needs a paid plan: daily on Starter, hourly on Pro. Plans cap refreshes and export runs per month |
| Zapier, Make and similar | Either way | A new Salesforce record or a new sheet row | Recipes such as each new lead becoming a sheet row, or each new row creating a lead | One workflow per direction to build and maintain, with optional AI steps. Salesforce is a Premium app on Zapier, so it needs a paid plan |
Salesforce and Google Sheets: the old way vs. Letaido
- 1Open the Salesforce report
- 2Export it as a CSV
- 3Open the sheet
- 4Clear yesterday's rows
- 5Paste the new rows
Every morning at 7am, run my Salesforce report 'Open pipeline by owner' and copy it to the 'Pipeline' tab of this sheet: [sheet link]. Put the report's column names in row 1, its rows below, and replace yesterday's rows.
Pipeline reporting, tab Pipeline
Dana Lee, Northwind Labs, annual, Northwind Labs
Dana Lee, Juniper & Co expansion, Juniper & Co
How Salesforce and Google Sheets jobs start
On a schedule
Saved as an automation, like these jobs: every morning at 7am, every Monday at 8am or on the 1st of every month. Neither app sends events to Letaido.
When you ask
Ask in chat; Leta picks from 100 actions.
How to set up the Salesforce Google Sheets integration
-
1Connect with Salesforce after a one time admin setup
-
2Connect Google Sheets with your OAuth client
-
3Approve the first Google Sheets run
Allow all read operations once per app; approve each kind of write once.
-
4Watch the first run in chat
-
5Pick a schedule
Every Salesforce and Google Sheets action the agent can take
Salesforce
12 groups: 42 reads, 25 writes
- Bulk load and export data
- Use list views
- Publish platform events
- 9 more
Get record blob · Create records · Upsert record · Delete records
Google Sheets
11 groups: 4 reads, 29 writes
- Write and append values
- Read spreadsheet structure
- Manage named ranges
- 8 more
Read values · Merge cells · Set data validation · Add conditional format rule
Frequently asked
Does Salesforce integrate with Google Sheets? +
Yes. Google's Data connector for Salesforce add-on imports reports and pushes edits you select back to Salesforce. With Letaido, Leta runs whole jobs both ways: a saved report copied to a tab every morning, a weekly pipeline snapshot, or a lead sheet imported without duplicates.
How do I connect Salesforce to Google Sheets with Letaido? +
Connect Salesforce after a one time admin setup, then connect Google Sheets with your own Google OAuth client. After that, type the job in chat or start from a prompt on this page.
Which sheet and Salesforce report does Leta use? +
Paste the sheet link in your request, as each prompt here does with [sheet link], and name the tab. For Salesforce, name the saved report, like 'Open pipeline by owner', and Leta finds it.
Can I export a Salesforce report to Google Sheets every day? +
Yes. Save it as a scheduled job: every morning Leta runs the report with its saved filters and rewrites one tab with its column names and rows. Keep your formulas and charts on another tab. A report run returns up to 2,000 rows.
Will a change in Salesforce or my sheet start a job? +
No. Neither Salesforce nor Google Sheets sends events to Letaido, so a change in either app can't start a job. Jobs run when you ask or on a schedule, such as every Monday at 8am.
How is Letaido different from the Data connector for Salesforce? +
Google's add-on imports a report or query and sends the rows you highlight back to Salesforce, when you run it. Leta runs the whole job for you on a schedule or when you ask, and checks each row, like skipping people who are already in Salesforce.
Is there a way to import a Google Sheet of leads into Salesforce without duplicates? +
Yes. Ask, and Leta skips anyone who is already a contact or an open lead, matched on email, creates the rest as leads using your assignment rule, and writes Created, Already in Salesforce or the problem next to each row.
What needs my approval in Salesforce or Google Sheets? +
Allow all read operations once per app; approve each kind of write once.
Put Salesforce and Google Sheets to work today
Connect Salesforce and Google Sheets, then ask for a job like "Copy our Salesforce pipeline report to our sheet every morning". Leta gets it done on your schedule, or the moment you ask.
Get Letaido