Google Sheets + My Web Audit
Trigger new My Web Audit audits from newly added Google Sheets rows
When a new row is added to your Google Sheets, this workflow will set off an audit for your Google Business Profile via the My Web Audit app. This simplifies your SEO tasks, ensuring your online presence remains optimized and relevant. Save time and increase efficiency by streamlining this essential business process.
When a new row is added to your Google Sheets, this workflow will set off an audit for your Google Business Profile via the My Web Audit app. This simplifies your SEO tasks, ensuring your online presence remains optimized and relevant. Save time and increase efficiency by streamlining this essential business process.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Run Audit - Google Business Profile (GBP)This action allows you to run a GBP audit.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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
Add New Task
Triggers when a new To-Do task is added to your account.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planAudit Email Sent
Triggers when an email has been sent for the audit the first time.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planAudit Submission
Triggers when a new audit generated including the company profile.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planLead Widget Submission
This trigger will be triggered when a lead widget submission occurs in your My Web Audit account.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCompany NameRequired
Website URLRequired
Name
Email
Phone
Template Token
LanguageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Name
Email
Phone
Template Token
LanguageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Name
Email
Phone
Template TokenRequired
Automatically Run System ChecksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Keyword Phrase
Name
Email
Phone
Primary Service Area
Template TokenRequired
Automatically Run System ChecksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Landing Page URLRequired
Name
Email
Phone
Location
Template TokenRequired
Automatically Run System ChecksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Name
Email
Phone
Primary Service Area
Template TokenRequired
Automatically Run System ChecksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URL
Name
Email
Phone
Average Monthly Website VisitorsRequired
Number of Monthly Sales GeneratedRequired
Average Sale Value ($)Required
Average Number of TransactionsRequired
Template TokenRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
KeywordRequired
Name
Email
Phone
Primary Service Area
Template Token
LanguageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Name
Email
Phone
Template Token
LanguageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Name
Email
Phone
Monthly Website VisitorsRequired
Monthly Leads GeneratedRequired
Qualified Leads (%)Required
Successful Customers (%)Required
Average Transaction Value ($)Required
Average Number of TransactionsRequired
Template Token
LanguageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
No 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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundAudit Email Read
Triggers when the user reads the email the first time.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planAudit Report Read
Triggers when the user views the report the first time.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planAudit Widget Submission
Triggers when a user submits the audit widget form on your website.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planName
Company Name
EmailRequired
Phone
Template Token
Website URLRequired
Primary Target Keyword
Enable Competitive AnalysisRequired
Competitor 1 Website URL
Competitor 2 Website URL
Automatically Run System Checks
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Keyword
Name
Email
Phone
Primary service area (City/State/Country)
Template TokenRequired
Automatically Run System ChecksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Name
Email
Phone
Template Token
LanguageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Primary KeywordRequired
Additional Keyword 1
Additional Keyword 2
Name
Email
Phone
Primary Target AddressRequired
Distance Between Grid PointsRequired
Distance TypeRequired
Competitor Company Name 1Required
Competitor Website URL 1Required
Competitor Primary Target Address 1
Competitor Company Name 2
Competitor Website URL 2
Competitor Primary Target Address 2
Template TokenRequired
Automatically Run System ChecksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Primary Keyword
Additional Keyword 1
Additional Keyword 2
Name
Email
Phone
Primary Service AreaRequired
Distance Between Grid PointsRequired
Distance TypeRequired
Template TokenRequired
Automatically Run System ChecksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Keyword PhraseRequired
Name
Email
Phone
Primary Service AreaRequired
Template TokenRequired
Automatically Run System ChecksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URL
Name
Email
Phone
Monthly Website VisitorsRequired
Monthly Leads GeneratedRequired
Qualified Leads (%)Required
Successful Customers (%)Required
Average Transaction Value ($)Required
Average Number of TransactionsRequired
Template TokenRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Keyword
Name
Email
Phone
Primary service area (City/State/Country)
Template TokenRequired
Automatically Run System ChecksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
KeywordRequired
Name
Email
Phone
Primary Service Area (City/State/Country)
Template Token
LanguageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Name
Email
Phone
Average Monthly Website VisitorsRequired
Monthly Sales GeneratedRequired
Average Sale Value ($)Required
Average Number of TransactionsRequired
Template Token
LanguageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Website URLRequired
Keyword
Name
Email
Phone
Primary Service Area (City/State/Country)
Template Token
LanguageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
About Google Sheets
Related categories
About My Web Audit
Related categories
Related Zap Templates
- Add new My Web Audit widget submissions to Google Sheets as spreadsheet rows
- Trigger competitive analysis audits in My Web Audit for new rows in Google Sheets
- Generate roi e-commerce magnets in My Web Audit for new rows in Google Sheets
- Run audits in My Web Audit for new rows in Google Sheets
- Generate roi lead magnets in My Web Audit for new spreadsheet rows in Google Sheets