ConditionalVisibility

new-products-promo

Automation inspiration

database-automation-00-hero

Airtable

Microsoft Excel

Google Sheets

Facebook Lead Ads

Typeform

Jotform

Using a spreadsheet or database app to track leads can make it easier to analyze data and share it with stakeholders across your company. 

How to add new leads to a spreadsheet or database automatically

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.

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 modified in a spreadsheet - works best with Team Drives.

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

Store responses from your forms directly in a spreadsheet! Use Zapier to automatically send those form responses right in a spreadsheet, and never worry about missing any submissions again.

Google Forms is an easy way to collect data from the web with a simple UI and powerful editor. Works hand-in-hand with Google Sheets!

Google Forms

Triggers when a new form response is received.

New Form Response

Triggers when a form response is added or modified.

New or Updated Form Response

Add Google Sheets rows for new Google Forms responses

Need to save your Gravity Forms submissions to a Google Sheets spreadsheet so you can easily share results with teammates and other collaborators outside of Gravity Forms? This Gravity Forms-Google Sheets integration makes it easy to do just that, automatically.

Gravity Forms is a premier WordPress plugin that makes it easy to create powerful forms on the fly.

Gravity Forms

Triggers when the specified form is submitted.

Form Submission

Create Entry

Creates an entry and fires all events associated with a form submission such as notifications and add-on feeds.

Submit Form

Create rows in Google Sheets for new Gravity Forms submissions

Forms are great at capturing user information, but exporting their results takes time. Zapier can help you analyze those entries in a spreadsheet automatically with this integration. Once you set it up, it will catch every new entry you receive on a Typeform, saving the results to a new row on Google Sheets so you don't have to do it yourself.

Typeform helps you ask awesomely online! If you ever need to run a survey, questionnaire, form, contest etc. Typeform will help you achieve it beautifully across all devices, every time, using its next generation platform.

New Entry

Retrieves ALL file(s) of a given form that are uploaded as part of form submission.

Retrieve ALL Files

Lookup Responses

Create an Empty Form

Duplicates an Existing Form

Update Dropdown, Multiple Choice or Ranking Question Options

Collect new Typeform responses as rows on Google Sheets

With this integration, you can have your JotForm submissions automatically added to Google Sheets so it's easier to share results with colleagues. After you set this up, every time there is a new JotForm response, a new row will be automatically added to a Google Sheets spreadsheet you specify.

The newly redesigned Jotform lets you build forms faster than ever, with powerful widgets and a responsive editor that works offline—without even needing to sign up for an account.

Triggers when a new submission has been added to a specific form.

New Submission

Triggers when a signed document is received.

New Signed Document

Assign Form

Invite assignees to complete your pre-populated form

Assign Prefilled Form

Create Submission

Save new JotForm responses as Google Sheets rows

The days of exporting your form submissions by hand are over. Set up this integration and Zapier will do it for you from now on. Any new Jotform submission will automatically create a new row on an Excel spreadsheet with all the responses you want, ready to be sorted, calculated, and analyzed at your leisure.

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. 

Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Triggers when a new row is added to a worksheet in a spreadsheet.

New Row

Triggers when a new row is added to a table in a spreadsheet.

New Row in Table

Triggers when a new worksheet is added to a spreadsheet.

Triggers when a row is added or updated in a worksheet.

Updated Row

Finds a row by a column and value. Returns the entire row if one is found.

Find Row

Finds any rows that match a specific value in a given column.

Find Row(s)

Adds a new row to the end of a worksheet.

Add Row

Adds one or more rows to the end of a worksheet (with line item support).

Add Row(s)

Adds a new row to the end of a specific table.

Add Row to Table

Update Row

Add new Jotform submissions to Excel spreadsheet rows

Your sales pipeline is only as good as the data you feed it. Save time by avoiding manual imports with this integration. Every new lead from Facebook Lead Ads will trigger the automation, logging the details into an Excel spreadsheet as a new row.

Add new Facebook Lead Ads leads to Excel

Looking to manage form responses from Google Forms in your Microsoft Excel account? This integration can help. When active, it tracks new entries and automatically adds them to a row in a specified Excel spreadsheet, saving you time for more important work!

Add new Google Forms responses to Microsoft Excel

The faster your form submissions come in, the harder it can be to track and store them all. You can set up this Zap, however, to capture everything for you. It will trigger whenever a new form submission is received in Gravity Forms, automatically adding that information to a row in a specified Excel spreadsheet and keeping your sheet constantly up to date for all your ensuing processes.

Add new Gravity Forms submissions to Excel rows

Whether you're planning an event or gathering product feedback, your time doesn't have to be spent exporting those results to your spreadsheets just so you can really go through them—we can do that! After you've set up this automation, Zapier will capture new entries your Typeform receives, adding a new row to an Excel spreadsheet for each and every one with every response you need.

Add new Typeform entries as rows on an Excel spreadsheet 

Rather than collecting and inputting data from endless amounts of form entries, use this Typeform to Airtable automation. Set it up and each time a new entry is submitted in Typeform, Zapier will create a new record in Airtable. Create complete and accurate records for your form entries in your Airtable database automatically!

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.

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

Add new Typeform entries to Airtable as records

Forms are a great way to gather a multitude of different pieces of data, why not store that in a place where you can work with it deeper? Connect your Google Forms responses to Airtable databases with the help of Zapier, and automatically store that valuable information in a place that works best for you.

Create Airtable records from new Google Forms responses

Don't let that valuable contact information go to waste. When someone expresses interest in your product or service through a Facebook ad, use this integration to capture their data automatically. After being set up, this Zap will add a record on Airtable for every new lead on Facebook as it happens, keeping your records up to date without any effort.

Add new Facebook Lead Ad leads to Airtable

Don't let data entry take up unnecessary time. With this automation, each time a new form is submitted in Jotform, Zapier will create a new record in Airtable. Create the forms and the results are collected automatically—no more endless hours behind a keyboard!

Archive new Jotform submissions in Airtable

Automatically add completed forms into your database with this Gravity Forms to Airtable automation. Once set up, each time a new form is submitted in Gravity Forms, Zapier will create a new record in Airtable. Organize and streamline the information you receive in your forms so you can access it quickly!

How to add new leads to a spreadsheet or database automatically

Related articles

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