Google Sheets + My Web Audit

Generate roi lead magnets in My Web Audit for new spreadsheet rows in Google Sheets

Capture opportunities and enhance your lead conversion with this useful workflow. When you add a new row in your Google Sheets, a ROI Lead Magnet will be instantly generated in your My Web Audit app. It not only streamlines your lead management process but also helps in thorough follow-ups. Turn your Google Sheets data into potent marketing tools with this seamless integration.

When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Generate ROI Lead MagnetThis action generates a lead magnet report.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google Sheets and My Web Audit

Discover other triggers and actions you can use with Google Sheets and My Web Audit

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write

- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- First row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet Name
  Required
- Search Type
- Spreadsheet to Copy
- Headers
Action
Search or write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
Audit Email Read
Triggers when the user reads the email the first time.
Trigger
Polling
Try It
Audit Report Read
Triggers when the user views the report the first time.
Trigger
Polling
Try It
Audit Widget Submission
Triggers when a user submits the audit widget form on your website.
Trigger
Polling
Try It
- Name
- Company Name
- Email
  Required
- Phone
- Template Token
- Website URL
  Required
- Primary Target Keyword
- Enable Competitive Analysis
  Required
- Competitor 1 Website URL
- Competitor 2 Website URL
- Automatically Run System Checks
Action
Write
- Company Name
  Required
- Website URL
  Required
- Keyword
- Name
- Email
- Phone
- Primary service area (City/State/Country)
- Template Token
  Required
- Automatically Run System Checks
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Name
- Email
- Phone
- Template Token
- Language
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Primary Keyword
  Required
- Additional Keyword 1
- Additional Keyword 2
- Name
- Email
- Phone
- Primary Target Address
  Required
- Distance Between Grid Points
  Required
- Distance Type
  Required
- Competitor Company Name 1
  Required
- Competitor Website URL 1
  Required
- Competitor Primary Target Address 1
- Competitor Company Name 2
- Competitor Website URL 2
- Competitor Primary Target Address 2
- Template Token
  Required
- Automatically Run System Checks
  Required
Action
Write
- Company Name
  Required
- Primary Keyword
- Additional Keyword 1
- Additional Keyword 2
- Name
- Email
- Phone
- Primary Service Area
  Required
- Distance Between Grid Points
  Required
- Distance Type
  Required
- Template Token
  Required
- Automatically Run System Checks
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Keyword Phrase
  Required
- Name
- Email
- Phone
- Primary Service Area
  Required
- Template Token
  Required
- Automatically Run System Checks
  Required
Action
Write
- Company Name
  Required
- Website URL
- Name
- Email
- Phone
- Monthly Website Visitors
  Required
- Monthly Leads Generated
  Required
- Qualified Leads (%)
  Required
- Successful Customers (%)
  Required
- Average Transaction Value ($)
  Required
- Average Number of Transactions
  Required
- Template Token
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Keyword
- Name
- Email
- Phone
- Primary service area (City/State/Country)
- Template Token
  Required
- Automatically Run System Checks
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Keyword
  Required
- Name
- Email
- Phone
- Primary Service Area (City/State/Country)
- Template Token
- Language
  Required
Action
Write
- Company Name
  Required
- Name
- Email
- Phone
- Average Monthly Website Visitors
  Required
- Monthly Sales Generated
  Required
- Average Sale Value ($)
  Required
- Average Number of Transactions
  Required
- Template Token
- Language
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Keyword
- Name
- Email
- Phone
- Primary Service Area (City/State/Country)
- Template Token
- Language
  Required
Action
Write

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write
- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Overwrite All Columns
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet Name
  Required
- Search Type
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
Add New Task
Triggers when a new To-Do task is added to your account.
Trigger
Polling
Try It
Audit Email Sent
Triggers when an email has been sent for the audit the first time.
Trigger
Polling
Try It
Audit Submission
Triggers when a new audit generated including the company profile.
Trigger
Polling
Try It
Lead Widget Submission
This trigger will be triggered when a lead widget submission occurs in your My Web Audit account.
Trigger
Polling
Try It
- Company Name
  Required
- Website URL
  Required
- Name
- Email
- Phone
- Template Token
- Language
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Name
- Email
- Phone
- Template Token
- Language
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Name
- Email
- Phone
- Template Token
  Required
- Automatically Run System Checks
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Keyword Phrase
- Name
- Email
- Phone
- Primary Service Area
- Template Token
  Required
- Automatically Run System Checks
  Required
Action
Write
- Company Name
  Required
- Landing Page URL
  Required
- Name
- Email
- Phone
- Location
- Template Token
  Required
- Automatically Run System Checks
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Name
- Email
- Phone
- Primary Service Area
- Template Token
  Required
- Automatically Run System Checks
  Required
Action
Write
- Company Name
  Required
- Website URL
- Name
- Email
- Phone
- Average Monthly Website Visitors
  Required
- Number of Monthly Sales Generated
  Required
- Average Sale Value ($)
  Required
- Average Number of Transactions
  Required
- Template Token
  Required
Action
Write
- Company Name
  Required
- Keyword
  Required
- Name
- Email
- Phone
- Primary Service Area
- Template Token
- Language
  Required
Action
Write
- Company Name
  Required
- Website URL
  Required
- Name
- Email
- Phone
- Template Token
- Language
  Required
Action
Write
- Company Name
  Required
- Name
- Email
- Phone
- Monthly Website Visitors
  Required
- Monthly Leads Generated
  Required
- Qualified Leads (%)
  Required
- Successful Customers (%)
  Required
- Average Transaction Value ($)
  Required
- Average Number of Transactions
  Required
- Template Token
- Language
  Required
Action
Write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About My Web Audit

My Web Audit is an audit and reporting tool to help agencies generate more leads and close more deals.

HelpHelp

Related categories

Marketing Automation

Similar apps

Zapier Forms

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

Related Zap Templates

Trigger competitive analysis audits in My Web Audit for new rows in Google Sheets