What happens if the company name doesn't match exactly between sheets and Salesforce?

The Zap will skip that record and log a 'no records found' error. Set up exact name matching or use external ID fields for more reliable lookups.

Can I update multiple Salesforce records if one company appears multiple times in my sheet?

Zapier's update action only modifies the first matching record found. If you have duplicate accounts in Salesforce, only one will be updated per spreadsheet row.

How quickly do updates appear in Salesforce after adding data to Google Sheets?

Typically 1-2 minutes on paid plans, up to 15 minutes on free plans. Google Sheets polling interval determines the delay more than Salesforce processing time.

Will this overwrite existing Salesforce data with blank values from my sheet?

Yes, mapped fields will be overwritten even if the new value is blank. Use conditional mapping or clean your sheet data to avoid losing existing Salesforce information.

Beginner~8 min setupProductivity & CRMVerified April 2026

How to Update Salesforce Accounts from Google Sheets Data with Zapier

Automatically enrich Salesforce account records when enrichment data is added to a Google Sheets spreadsheet.

Steps and UI details are based on platform versions at time of writing — check each platform for the latest interface.

Zapier

Also on:Make N8n

Best for

Small to medium sales teams enriching under 500 accounts monthly who want reliable, no-code automation

Not ideal for

High-volume operations processing thousands of records or teams needing complex data transformations

Sync type

real-time

Use case type

sync

Real-World Example

💡

A 25-person B2B SaaS company uses this to enrich Salesforce accounts with firmographic data from their sales development tool. When their SDR team adds company size, industry, and revenue data to a Google Sheet, Zapier automatically updates the corresponding Salesforce accounts within 2 minutes. Before automation, sales reps manually copied enrichment data between systems, taking 3-4 minutes per account and often forgetting to update records for weeks.

What Will This Cost?

Drag the slider to your expected monthly volume.

Monthly workflow runs

/mo

505005K50K

Each platform counts differently — Zapier: 1 task per trigger. Make: 1 operation per module per record. n8n: 1 execution per run.

$30/mo if billed monthly

Pipedream

$29/mo

Basic plan

Prices shown for annual billing. Based on published pricing as of April 2026.

Estimated ROI

1000

min saved/mo

$583

labor value/mo

Free

no platform cost

Based on ~2 min manual effort per operation at $35/hr fully loaded labor cost.

Implementation

Before You Start

Make sure you have everything ready.

Google Sheets spreadsheet with account enrichment data including company names that match Salesforce

Salesforce account with user permissions to update Account records

Zapier account on Starter plan or higher for multi-step Zaps

Consistent naming convention between Google Sheets company names and Salesforce Account names

Enrichment process that populates a trigger column when data is complete

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
Account Name	`Name`	Company name used to match records between Google Sheets and Salesforce

5 optional fields▸ show

Industry	`Industry`	Standard Salesforce industry picklist value from enrichment data
Employee Count	`NumberOfEmployees`	Number of employees at the company from enrichment tools
Annual Revenue	`AnnualRevenue`	Company annual revenue in dollars from financial databases
Website	`Website`	Company website URL validated and cleaned from enrichment
Company Description	`Description`	Business description text from company websites or databases

Step-by-Step Setup

Dashboard > Create Zap > Google Sheets

Create New Zap

Start a new automation in Zapier. The trigger will monitor your Google Sheets spreadsheet for new enrichment data.

1Click 'Create Zap' from your Zapier dashboard
2Select Google Sheets from the app list
3Choose 'New or Updated Spreadsheet Row' as your trigger

✓ What you should see: You should see the Google Sheets trigger configuration screen with dropdown menus for spreadsheet and worksheet selection.

Trigger > Google Sheets > Account

Connect Google Sheets Account

Authorize Zapier to access your Google Sheets. This requires Google account permissions for reading spreadsheet data.

1Click 'Sign in to Google Sheets'
2Select your Google account from the popup
3Click 'Allow' when prompted for spreadsheet permissions
4Verify the green 'Connected' status appears

✓ What you should see: Google Sheets shows as connected with your account email displayed below the connection button.

⚠

Common mistake — Use the same Google account that owns your enrichment spreadsheet — shared sheets often cause permission errors later.

Zapier settings

Connection

Choose a connection…Add

click Add

Google Sheets

Authorize Zapier

popup window

✓

Connected

green checkmark

Trigger > Google Sheets > App & Event

Select Spreadsheet and Worksheet

Choose the specific spreadsheet and worksheet containing your account enrichment data. Zapier will monitor this sheet for new rows.

1Select your enrichment spreadsheet from the 'Spreadsheet' dropdown
2Choose the worksheet tab containing account data
3Set 'Trigger Column' to the column that gets updated last in your enrichment process
4Click 'Continue'

✓ What you should see: The spreadsheet and worksheet names appear in the dropdowns, with your trigger column selected.

⚠

Common mistake — Pick a trigger column that's always populated when enrichment completes — empty cells won't fire the trigger.

Trigger > Test

Test Google Sheets Trigger

Zapier pulls a sample row from your spreadsheet to map fields later. This validates your sheet connection and shows available data.

1Click 'Test trigger'
2Wait for Zapier to find recent spreadsheet rows
3Select a sample row that contains complete enrichment data
4Click 'Continue with selected record'

✓ What you should see: Sample data appears showing column headers and values from your selected row, like Company Name, Industry, Employee Count.

⚠

Common mistake — Choose a row with real enrichment data, not headers or test data — this sample determines available fields for mapping.

Zapier

▶ Turn on & test

executed

✓

Google Sheets

✓

Salesforce

🔔 notification

received

Action > App Selection > Salesforce

Add Salesforce Action

Configure Salesforce as the action app. You'll update existing account records based on data from your enrichment spreadsheet.

1Click the '+' button to add an action step
2Search for and select 'Salesforce'
3Choose 'Update Record' as the action event
4Click 'Continue'

✓ What you should see: Salesforce appears as your action app with 'Update Record' selected as the event type.

Action > Salesforce > Account

Connect Salesforce Account

Authenticate with Salesforce to allow record updates. Zapier needs permissions to read and modify account records in your org.

1Click 'Sign in to Salesforce'
2Enter your Salesforce username and password
3Click 'Allow' to grant Zapier API access
4Verify connection shows your Salesforce org name

✓ What you should see: Salesforce connection displays as active with your org name and user email visible.

⚠

Common mistake — Use a Salesforce user with modify permissions on Account records — read-only users will cause the Zap to fail.

Action > Salesforce > Set up Action

Configure Record Lookup

Set up how Zapier finds the correct Salesforce account to update. This typically matches on account name or external ID from your spreadsheet.

1Select 'Account' from the 'Record Type' dropdown
2Choose your lookup field (usually 'Name' or 'External ID')
3Map this to the corresponding company name column from your Google Sheet
4Set 'Should this step be considered a success when nothing is found?' to 'No'

✓ What you should see: The record lookup section shows Account selected with your chosen field mapped to spreadsheet data.

⚠

Common mistake — Account names must match exactly between sheets and Salesforce — even extra spaces will prevent matches.

Action > Salesforce > Field Mapping

Map Enrichment Fields

Connect enrichment data from your spreadsheet to Salesforce account fields. This determines what gets updated when the Zap runs.

1Click in the 'Industry' field and select your industry column from the sheet
2Map 'NumberOfEmployees' to your employee count column
3Connect 'Website' to your website URL column
4Map any custom fields like 'Annual_Revenue__c' to corresponding sheet columns

✓ What you should see: Salesforce fields show mapped to Google Sheets columns with dynamic field references like '1. Industry' visible in each field.

⚠

Common mistake — Only map fields that contain clean, validated data — bad data will update Salesforce records and create cleanup work.

Google Sheets fields

Column A

Column B

Status

Notes

available as variables:

1.props.Column A

1.props.Column B

1.props.Email

1.props.Status

1.props.Notes

Action > Test

Test Salesforce Update

Run a test update to verify field mapping and permissions. Zapier will attempt to update a real Salesforce record using your sample data.

1Click 'Test action' at the bottom of the mapping section
2Wait for Zapier to search for and update the Salesforce record
3Review the test results showing which fields were updated
4Click 'Continue'

✓ What you should see: Test results show 'Success' with details of the updated Salesforce record and which fields changed.

⚠

Common mistake — This test updates a real Salesforce record — verify the sample data is accurate before running the test.

Publish > Zap Settings

Name and Activate Zap

Give your Zap a descriptive name and turn it on. Once active, it will monitor your spreadsheet and update Salesforce accounts automatically.

1Click 'Publish' in the top right corner
2Enter a name like 'Google Sheets to Salesforce Account Enrichment'
3Toggle the Zap status to 'On'
4Click 'Publish Zap' to activate

✓ What you should see: Your Zap appears in the dashboard with 'On' status and starts monitoring for new spreadsheet updates.

Drop this into a Zapier Code step.

JavaScript — Code Step={{if(1.Industry__Sheet != "", 1.Industry__Sheet, "Unknown")}}

▸ Show code

={{if(1.Industry__Sheet != "", 1.Industry__Sheet, "Unknown")}} 
Use this formula in Salesforce Industry field mapping to set "Unknown" when enrichment data is empty, preventing blank field overwrites.

... expand to see full code

={{if(1.Industry__Sheet != "", 1.Industry__Sheet, "Unknown")}} 

Use this formula in Salesforce Industry field mapping to set "Unknown" when enrichment data is empty, preventing blank field overwrites.

Scaling Beyond 500+ enrichments per month+ Records

If your volume exceeds 500+ enrichments per month records, apply these adjustments.

Upgrade to Professional Plan

Starter plan's 750 tasks won't handle 500+ enrichments needing 2 tasks each. Professional gives you 2000 tasks at $49/month with faster execution times.

Batch Updates Weekly

Instead of real-time sync, accumulate enrichment data and update Salesforce in weekly batches. This reduces task consumption and avoids API rate limits during heavy enrichment periods.

Going live

Production Checklist

Before you turn this on for real, confirm each item.

Test with 5-10 real enrichment records to verify field mapping accuracy

Applies when: Always

Set up Zap failure notifications to your email or Slack channel

Applies when: Always

Verify Salesforce user permissions include modify access on all mapped fields

Applies when: Always

Create a backup of Account records before activating if enriching existing data

Applies when: Always

Configure task usage alerts at 80% of plan limit to avoid overages

Applies when: High volume

Set up duplicate detection rules in Salesforce to prevent bad data updates

Applies when: Enterprise

Troubleshooting

Common errors and how to fix them.

Frequently Asked Questions

Common questions about this workflow.

Analysis

VerdictWhy Zapier for this workflow

Use Zapier for this if your team doesn't code and you're enriching under 500 accounts monthly. The visual interface makes field mapping simple and error handling is built-in. You get real-time updates within 1-2 minutes of adding enrichment data to your sheet. Skip Zapier if you're processing thousands of records — Make handles higher volumes better at the same price point.

Cost

This workflow burns 2 tasks per enrichment (record lookup + update). At 200 enrichments monthly, that's 400 tasks fitting the Starter plan at $19.99. For 500+ enrichments you need Professional at $49/month for 2000 tasks. Make costs the same but gives you 10,000 operations on their Core plan. N8N self-hosted is free but requires server management.

Tradeoffs

Make beats Zapier on bulk operations with better array handling and lower per-operation costs at volume. N8N offers more advanced data transformation with JavaScript expressions and custom HTTP requests. But Zapier wins on reliability — their Salesforce connector handles API limits and retries automatically, while Make sometimes fails on large record updates without manual error handling configuration.

You'll hit Google Sheets API rate limits around 100 requests per 100 seconds if enriching rapidly. Salesforce duplicate rules will block updates if your org has strict matching enabled. The biggest gotcha: Zapier caches spreadsheet column headers for 5 minutes, so adding new columns requires waiting or manually refreshing the Zap trigger configuration.

Ideas for what to build next

→
Add Slack Notifications for Failed Updates — Create a second Zap that sends Slack alerts when Salesforce updates fail, so your team knows when enrichment data didn't sync properly.
→
Create Contact Enrichment Workflow — Build a parallel automation that updates Salesforce Contact records when enrichment tools provide individual contact data like job titles and email addresses.
→
Set Up Opportunity Scoring Updates — Use the enriched account data to automatically update opportunity scores or stages based on company size, industry, or revenue thresholds in Salesforce.