Google Ads + Google Sheets
Create spreadsheets in Google Sheets for new lead form entries in Google Ads
When a new lead form entry is detected within Google Ads, this workflow instantly adds the data into a new row in your Google Sheets spreadsheet. This easy automation saves you the task of manual data entry, keeping all your leads organized in one place for quick reference and follow-up. Stay on top of your Google Ads leads with this simple yet efficient workflow.
When a new lead form entry is detected within Google Ads, this workflow instantly adds the data into a new row in your Google Sheets spreadsheet. This easy automation saves you the task of manual data entry, keeping all your leads organized in one place for quick reference and follow-up. Stay on top of your Google Ads leads with this simple yet efficient workflow.
- When this happens...
New Lead Form EntryTriggers whenever a new lead is created from a Lead Form Extension.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create SpreadsheetCreates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Campaign
Triggers whenever a new campaign is created in Google Ads.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUse Google Ads as...Required
Managed Account
Customer ListRequired
EmailRequired
Message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Description
Message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Use Google Ads as...Required
Managed Account
Customer ListRequired
Customer IdentifierRequired
Message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Use Google As...Required
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Use Google Ads as...Required
Managed Account
Lead FormRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUse Google Ads as...Required
Managed Account
Customer ListRequired
Customer IdentifierRequired
Message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Use Google Ads as...Required
Managed Account
ResourceRequired
Dates to IncludeRequired
Limit
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Double Opt Message
Use Google Ads as...Required
Managed Account
Multiple Identifier Note
Conversion User Identifier SourceRequired
Conversion ActionRequired
TimestampRequired
Value
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Use Google As...Required
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Description
Message
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Ads
Google Ads (formerly Google AdWords) is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web users.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Create Google Sheets rows for new Google Ads leads
- Log Google Ads offline conversions from new rows in Google Sheets
- Add contacts to Google Ads customer lists from new Google Sheets rows
- Send Offline Conversion to Google Ads for New or Updated Spreadsheet Row in Google Sheets
- Trigger offline conversions in Google Ads with new or updated rows in Google Sheets
- Add people to Google Ads Customer Lists from new Google Sheets rows
- Send Offline Conversion to Google Ads for New Spreadsheet Row in Google Sheets
- Update Google Sheets spreadsheet rows to add them to Google Ads Custom Lists
- Create spreadsheets on Google Sheets for new Google Ads leads
- Add Contact to Customer List With Email in Google Ads for New or Updated Spreadsheet Row in Google Sheets
- Send offline conversions in Google Ads with new Google Sheets (Team Drive) rows
- Add new leads in Google Ads to Google Sheets rows
- Add people to Google Ads Customer Lists for new Google Sheets rows in a team drive
- Create Worksheet in Google Sheets for new lead form entries in Google Ads
- Add Contact to Customer List With Email in Google Ads for New Spreadsheet Row in Google Sheets
- Generate rows in Google Sheets for the start of new Google Ads campaigns
- Update Google Sheets spreadsheet rows to add them to Google Ads Customer Lists
- Add new Google Sheets spreadsheets to Google Ads as contacts for customer list with email
- Create new Google Ads contacts from new Google Sheets spreadsheets
- Update Google Sheets rows with new leads in Google Ads
- Add people to Google Ads Custom Lists for new Google Sheets rows in a team drive
- Update offline conversions in Google Ads for new or updated rows in Google Sheets
- Create customer lists in Google Ads from new worksheets in Google Sheets
- Add Google Ads contacts to customer lists with new or updated Google Sheets rows
- "create spreadsheet columns in Google Sheets for new campaigns in Google Ads"
- Create reports in Google Ads from new rows in Google Sheets
- Send Google Ads offline conversions when new rows are added in Google Sheets
- Launch/stop new campaigns in Google Ads with Google Sheets row updates
- Create Spreadsheet Row in Google Sheets for new lead form entries in Google Ads
- Send Offline Conversion to Google Ads for New Spreadsheet in Google Sheets
- Add contacts to a Google Ads customer list for new or updated spreadsheet rows (Team Drive) on Google Sheets
- Add contacts to a Google Ads customer list for new spreadsheet rows (Team Drive) on Google Sheets
- Create worksheets on Google Sheets for new Google Ads leads
- Copy worksheets on Google Sheets for new Google Ads leads
- Add Google Ads contacts to customer lists with new Google Sheets rows
- Create Spreadsheet Row(s) in Google Sheets for new lead form entries in Google Ads
- Update Spreadsheet Row in Google Sheets for new lead form entries in Google Ads
- Create Spreadsheet in Google Sheets for new lead form entries in Google Ads
- Create Spreadsheet Column in Google Sheets for new lead form entries in Google Ads
- Create Response in Google Forms for new lead form entries in Google Ads
- Send Offline Conversion to Google Ads for New Spreadsheet Row (Team Drive) in Google Sheets
- Send Offline Conversion to Google Ads for New or Updated Spreadsheet Row (Team Drive) in Google Sheets
- Add Contact to Customer List With Email in Google Ads for New Spreadsheet Row (Team Drive) in Google Sheets
- Add Contact to Customer List With Email in Google Ads for New or Updated Spreadsheet Row (Team Drive) in Google Sheets
- Create spreadsheets in Google Sheets for new lead form entries in Google Ads
- Create customer lists in Google Ads from new spreadsheets in Google Sheets
- Add new Google Sheets rows to create customer lists in Google Ads
- Create customer lists in Google Ads from new or updated Google Sheets rows
- Update Google Ads app extensions with new or updated rows from Google Sheets
- Create spreadsheets in Google Sheets from new campaigns in Google Ads
- Create new Google Sheets worksheets for new Google Ads campaigns
- Create a copy of worksheet in Google Sheets for new campaigns in Google Ads
- Format rows in Google Sheets for new campaigns from Google Ads
- Create new extensions in Google Sheets when new lead form entries appear in Google Ads
- Update rows in Google Sheets when new lead form entries are detected in Google Ads
- Create Google Sheets extensions for each new Google Ads campaign
- Create multiple rows in Google Sheets for every new campaign in Google Ads
- Update spreadsheet rows in Google Sheets when new campaigns are launched in Google Ads
- Update Google Sheets rows with new Google Ads campaigns
- Delete rows in Google Sheets when new lead form entries occur in Google Ads
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Generate multiple rows in Google Sheets for every new lead form entry in Google Ads
- Add new Google Ads leads to a Google Sheets worksheet
- Clear rows in Google Sheets when new lead form entries occur in Google Ads
- Update Google Sheets rows with new Google Ads leads form entries
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Create spreadsheets in Google Sheets for new lead form entries in Google Ads
- Create worksheets in Google Sheets for new lead form entries in Google Ads
- Clear rows in Google Sheets when new lead form entries occur in Google Ads
- Add new Google Ads leads to multiple Google Sheets rows instantly
- Add new or updated Google Sheets rows to Google Ads contact list
- Add new Google Sheets rows to Google Ads contact list with email
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Add contacts to Google Ads customer list with email when new or updated rows are detected in Google Sheets
- Copy new Google Ads lead form entries to Google Sheets worksheets
Related Zap Templates
- Create Google Sheets rows for new Google Ads leads
- Send Offline Conversion to Google Ads for New or Updated Spreadsheet Row in Google Sheets
- Send Offline Conversion to Google Ads for New Spreadsheet Row in Google Sheets
- Add Contact to Customer List With Email in Google Ads for New or Updated Spreadsheet Row in Google Sheets
- Add people to Google Ads Customer Lists for new Google Sheets rows in a team drive
- Generate rows in Google Sheets for the start of new Google Ads campaigns
- Create new Google Ads contacts from new Google Sheets spreadsheets
- Update offline conversions in Google Ads for new or updated rows in Google Sheets
- "create spreadsheet columns in Google Sheets for new campaigns in Google Ads"
- Launch/stop new campaigns in Google Ads with Google Sheets row updates
- Add contacts to a Google Ads customer list for new or updated spreadsheet rows (Team Drive) on Google Sheets
- Copy worksheets on Google Sheets for new Google Ads leads
- Update Spreadsheet Row in Google Sheets for new lead form entries in Google Ads
- Create Response in Google Forms for new lead form entries in Google Ads
- Add Contact to Customer List With Email in Google Ads for New Spreadsheet Row (Team Drive) in Google Sheets
- Create customer lists in Google Ads from new spreadsheets in Google Sheets
- Update Google Ads app extensions with new or updated rows from Google Sheets
- Create a copy of worksheet in Google Sheets for new campaigns in Google Ads
- Update rows in Google Sheets when new lead form entries are detected in Google Ads
- Update spreadsheet rows in Google Sheets when new campaigns are launched in Google Ads
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Clear rows in Google Sheets when new lead form entries occur in Google Ads
- Create spreadsheets in Google Sheets for new lead form entries in Google Ads
- Add new Google Ads leads to multiple Google Sheets rows instantly
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Log Google Ads offline conversions from new rows in Google Sheets
- Trigger offline conversions in Google Ads with new or updated rows in Google Sheets
- Update Google Sheets spreadsheet rows to add them to Google Ads Custom Lists
- Send offline conversions in Google Ads with new Google Sheets (Team Drive) rows
- Create Worksheet in Google Sheets for new lead form entries in Google Ads
- Update Google Sheets spreadsheet rows to add them to Google Ads Customer Lists
- Update Google Sheets rows with new leads in Google Ads
- Create customer lists in Google Ads from new worksheets in Google Sheets
- Create reports in Google Ads from new rows in Google Sheets
- Create Spreadsheet Row in Google Sheets for new lead form entries in Google Ads
- Add contacts to a Google Ads customer list for new spreadsheet rows (Team Drive) on Google Sheets
- Add Google Ads contacts to customer lists with new Google Sheets rows
- Create Spreadsheet in Google Sheets for new lead form entries in Google Ads
- Send Offline Conversion to Google Ads for New Spreadsheet Row (Team Drive) in Google Sheets
- Add Contact to Customer List With Email in Google Ads for New or Updated Spreadsheet Row (Team Drive) in Google Sheets
- Add new Google Sheets rows to create customer lists in Google Ads
- Create spreadsheets in Google Sheets from new campaigns in Google Ads
- Format rows in Google Sheets for new campaigns from Google Ads
- Create Google Sheets extensions for each new Google Ads campaign
- Update Google Sheets rows with new Google Ads campaigns
- Generate multiple rows in Google Sheets for every new lead form entry in Google Ads
- Update Google Sheets rows with new Google Ads leads form entries
- Create worksheets in Google Sheets for new lead form entries in Google Ads
- Add new or updated Google Sheets rows to Google Ads contact list
- Add contacts to Google Ads customer list with email when new or updated rows are detected in Google Sheets
- Add contacts to Google Ads customer lists from new Google Sheets rows
- Add people to Google Ads Customer Lists from new Google Sheets rows
- Create spreadsheets on Google Sheets for new Google Ads leads
- Add new leads in Google Ads to Google Sheets rows
- Add Contact to Customer List With Email in Google Ads for New Spreadsheet Row in Google Sheets
- Add new Google Sheets spreadsheets to Google Ads as contacts for customer list with email
- Add people to Google Ads Custom Lists for new Google Sheets rows in a team drive
- Add Google Ads contacts to customer lists with new or updated Google Sheets rows
- Send Google Ads offline conversions when new rows are added in Google Sheets
- Send Offline Conversion to Google Ads for New Spreadsheet in Google Sheets
- Create worksheets on Google Sheets for new Google Ads leads
- Create Spreadsheet Row(s) in Google Sheets for new lead form entries in Google Ads
- Create Spreadsheet Column in Google Sheets for new lead form entries in Google Ads
- Send Offline Conversion to Google Ads for New or Updated Spreadsheet Row (Team Drive) in Google Sheets
- Create spreadsheets in Google Sheets for new lead form entries in Google Ads
- Create customer lists in Google Ads from new or updated Google Sheets rows
- Create new Google Sheets worksheets for new Google Ads campaigns
- Create new extensions in Google Sheets when new lead form entries appear in Google Ads
- Create multiple rows in Google Sheets for every new campaign in Google Ads
- Delete rows in Google Sheets when new lead form entries occur in Google Ads
- Add new Google Ads leads to a Google Sheets worksheet
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Clear rows in Google Sheets when new lead form entries occur in Google Ads
- Add new Google Sheets rows to Google Ads contact list with email
- Copy new Google Ads lead form entries to Google Sheets worksheets