ConditionalVisibility

new-products-promo

Automation inspiration

automate data analytics hero

Google Sheets

Google Analytics

Hotjar

MySQL

Learn how to use Zapier's automated workflows to connect lead data, customer touch points, and analytics tools—organizing your data so you can turn it into actionable insight.

4 ways marketers can automate data analytics

Spreadsheets make it easy to filter and sort through new prospects, but take time to build. Use this Facebook Lead Ads-Google Sheets integration to link your records directly to your ads so you can keep your mind on marketing. After being set up, every new ad lead on Facebook will trigger this Zap, automatically creating a new row on Google Sheets with all those valuable details for you. Learn more in our 

Facebook lead ads make signing up for business information easy for people and more valuable for businesses. The Facebook lead ad app is useful for marketers who want to automate actions on their leads.

Facebook Lead Ads

New Lead

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

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Add new Facebook Lead Ads leads to rows on Google Sheets

Your time is best spent nurturing new prospects, not on data entry. Set up this integration to automatically save information submitted by new leads to your LinkedIn Lead Gen Form to a new row in a specified Google Sheets spreadsheet. Sort and filter through them at will, while saving time and effort! 

LinkedIn Ads allows marketers to collect even more quality leads from their ads and events on LinkedIn with seamless pre-filled forms.

LinkedIn Ads

Triggers when you receive a new form response tied to a Company Page, Product Page, or Event.

New Lead Gen Form Response (Organic Content)

Triggers when you receive a new form response for an ad.

New Lead Gen Form Response (Sponsored content)

Add Company to Audience

Add Contact to Audience

Creates an Audience that you can add Contacts or Companies to.

Create Audience

Sends a Conversion Event to a Conversion.

Send Conversion Event

Removes an email address from an Audience.

Remove Email from Audience

Create Report

Add new  leads in LinkedIn Ads to Google Sheets rows

This integration makes it easy to keep track of your new leads in a spreadsheet. When it is up-and-running, every new lead from TikTok Lead Generation will be added to Google Sheets row(s).

TikTok's Lead Generation enables businesses of all sizes to create seamless interactions to reach prospects in order to convert them into potential customers.

TikTok Lead Generation

Create Google Sheets row(s) for new TikTok Lead Generation leads

Using Google Sheets is a great way to track and break down your marketing ROI, but your focus should be on analysis, not spreadsheet wrangling. This integration saves you the time and effort of manual updates, creating new rows in a specific spreadsheet in Google Sheets whenever a new Google Ads campaign launches. Cut right to the heart of the data without wasting your time with formats and layouts.

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.

Google Ads

Triggers whenever a new campaign is created in Google Ads.

New Campaign

Triggers whenever a new lead is created from a Lead Form Extension.

New Lead Form Entry

Finds a Google Ads Campaign whose id matches the provided input.

Find Campaign by Id

Finds a Google Ads Campaign whose names matches the provided input.

Find Campaign by Name

Find Customer List

Finds a customer list by name. Optionally creates a new customer list.

Find or Create Customer List

Adds a contact to a customer list using their email address. Note: It takes 6 to 12 hours for the customer list to be populated with contacts.

Add Contact to Customer List With Email

Adds a contact to a customer list. Note: It takes 6 to 12 hours for the customer list to be populated with contacts.

Add Contact to Customer List

Creates a customer list in Google Ads Audience Manager.

Create Customer List

Creates a report on specified data from your campaigns/ads.

Remove Contact From Customer List

Sends events from your customer systems (PoS, CRM, email service provider, etc) to connect Google Ad campaigns to offline activity and business impact.

Send Offline Conversion

Sets the status of a Google Ads campaign.

Set Campaign Status

Generate rows in Google Sheets for the start of new Google Ads campaigns

Simplify how you sort and track Hotjar feedback by automatically creating a new row in a Google sheet when new Hotjar feedback responses come in. With all of your feedback in one place, you can easily sort and filter responses based on the criteria that matters to you.

Traditional web analytics tools help you analyze traffic data. But numbers alone can’t tell you what users really do on your site — Hotjar will.

Triggers when a new Feedback Response is created.

New Feedback

Triggers when a new Recording is created.

New Recording

Triggers when a new Survey response is created.

New Survey Response

Add rows to a Google sheet for new Hotjar incoming feedback responses

If you're wanting to keep an archive of new email subscribers you collected through BDOW!, use this Zapier integration to save the subscriber's name, email address and whatever other information you're collecting.

BDOW!, grow your email lists while turning leads into conversions with our pop-up and form tool for websites.

BDOW (FKA Sumo)

Triggers when a new email subscriber is created

New Email Subscriber

Create an event where a user completed an action

Records a Social Proof Event

Save new BDOW! email subscribers to a Google Sheets spreadsheet

Need a place to store all of your survey responses from Hotjar? With this Zap, you can automatically create a new record in Airtable whenever a new survey response is submitted in Hotjar, helping you stay organized and keep track of your survey data efficiently.

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Airtable

Triggers when a new record is created or new or existing records when first added to a selected view.

New Record

Triggers when a record is created or updated.

New or Updated Record

Find Many Records (Advanced)

Find Record

Find or Create Record(s) (With Line Item Support)

Find or Create Record

Creates a new record with auto-populating fields.

Create Record

Create up to 10 new records (supports line items).

Create Records (Advanced)

Find and update an existing record, or create a new one.

Create or Update Record

Delete Record

Update Record

Create new records in Airtable for new Hotjar survey responses

Recruiting for user interviews can take a lot of time but this integration helps you to lighten the load. A new card will populate on your Trello board every time a user leaves their contact information in a new Hotjar survey response. From here you can quickly sort the cards to drive interviews forward so you can focus on what matters the most — learning from your users.

Trello is a team collaboration tool that lets you organize anything and everything to keep your projects on task.

Trello

New Board

New Card

Triggers when a Card is archived in Trello.

New Card Archived

Triggers when a Comment is added to a Card in Trello.

New Comment in Card

Triggers when there is activity in Trello.

New Activity

Triggers when a Card is moved to a List in Trello, [inside the same Board](https://zapier.com/apps/trello/help#common-problems-trello#not-triggering-on-card-moved-to-list-when-a-card-is-moved-from-another-board).

Card Moved to List

Triggers at a specified time before a card is due.

Card Due

Triggers when a Card is updated in Trello.

Card Updated

Triggers when a new checklist is created in Trello.

New Checklist

Triggers when a new label is created in Trello.

New Label

Triggers when a label is added in a Trello card.

New Label Added to Card

Triggers when a new list on a board is added.

New List

Triggers when a new member joins a board.

New Member on Board

Triggers when you get a new notification in Trello.

New Notification

Finds a label on a particular board by name.

Find Label on Board

Finds a list on a particular board by name.

Find List on a Board

Finds a checklist on a particular board or card by name.

Find Checklist

Finds a checklist item on a particular checklist by name.

Find Checklist Item

Finds a board in your Trello organization by name.

Find Board

Finds a card in your Trello organization by name, given a specified board and list. Does not search archived cards.

4 ways marketers can automate data analytics

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.