ConditionalVisibility

new-products-promo

Find a Zap quiz

Zapier tutorials

zapier-tutorials-00-form-spreadsheet

What if you could automatically back up the important information you get through forms in a database, without ever having to think about it?

How to automatically add leads from forms to your database or spreadsheet

Often it's helpful to store, backup and organize emails matching certain characteristics to a Google Spreadsheet. This Gmail Google Sheets integration makes it a breeze to setup a simple rule (i.e. emails from: 

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

Gmail

Triggers when you receive a new attachment.

New Attachment

New Label

Triggers when you receive a new email and label it within two days.

New Labeled Email

Triggers when a new email appears in the specified mailbox.

New Email

Triggers when you receive a new email that matches a search string you provide.

New Email Matching Search

Triggers when you receive a new email and star it within two days.

New Starred Email

New Thread

Find Email

Find or Send Email

Add Label to Email

Delete Email

Create Draft

Create a draft reply to an existing email.

Create Draft Reply

Create Label

Send Email

Remove Label From Email

Reply to Email

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

Google Sheets

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 spreadsheet row at the top of a spreadsheet (after the header row).

Create Spreadsheet Row at Top

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)

Save new Gmail emails matching certain traits to a Google Spreadsheet

Automatically log new Outlook email messages with a specific term in the subject line in a Microsoft Excel workbook to create an archive of invoices, expenses, or other often-received messages.

Microsoft Outlook is a web-based suite of webmail, contacts, tasks, and calendaring services.

Microsoft Outlook

Triggers at a specified time before an event in your calendar starts.

Calendar Event Start

Cancelled Calendar Event

Triggers when a new event is created in your calendar.

New Calendar Event

Triggers when a new contact is added to your account

New Contact

Triggers when a new e-mail is received in your inbox.

Triggers when a new e-mail is received in your inbox that matches a search.

New Flagged Email

Triggers when a new new message in folder is created.

New Message in Folder

Updated Calendar Event

Find Calendar Event

Find a Contact

Find or Create Contact

Add Attendees to Calendar Event

Create an event in the calendar of your choice.

Create Event

Create Contact

Creates a draft of an email that can then be reviewed and sent out.

Create Draft Email

Delete Event

Creates a new reply to email, probably with input from previous steps.

Update Calendar Event

Update Contact

Only allow a Zap to proceed when a certain condition is met. For example, if you're sending a text message when you receive a new email, you could use a Filter that only sends a text message when the email received is from a certain address.

Set up rules to specify when this Zap can continue running.

Only continue if...

Filter by Zapier

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.

Microsoft Excel

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 row in Microsoft Excel for new Outlook emails with specific term in the subject line

If you're looking for specific parts of emails you receive regularly, Zapier's Email Parser can extract the contents you need, and this integration makes things even easier. Once it's active, Zapier will parse emails sent to your Parser Mailbox, extracting information according to your rules and sending that on to a specified Excel spreadsheet in a new row, archiving exactly what you need.

Send emails to your custom "@robot.zapier.com" address and extract any data! Visit http://parser.zapier.com/ for more information!

Email Parser by Zapier

Triggers when a mailbox gets a new email. Don't forget to set up your parser mailboxes at https://parser.zapier.com/.

New Mailbox

Parse new emails with Zapier and add them to Excel rows

Want a quick way to keep track of your most important emails? This Gmail-Airtable integration can help. Set it up, and whenever you label a new email in Gmail, Zapier will automatically copy the email's details and log it to your Airtable database. Set up your Gmail filters to automatically label emails (

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

Add new labeled Gmail messages to Airtable

Forget manual exports. Automation can keep a log of all your form responses while you're busy with work that matters. After you turn on this integration, it will trigger with every new form submission you get on Unbounce, automatically adding a new row on Google Sheets for each one. You'll never have to worry about copy/pasting again.

Unbounce is a landing page platform that helps you convert more visitors into leads, sales, and customers. Unbounce Conversion Intelligence™ is AI powered-functionality that works with your marketing intuition to ensure the best campaign performance every time.

Unbounce

Triggers when a new Form Submission is received on a Landing Page, Overlay or Sticky Bar.

New Form Submission

Generate rows in Google Sheets for new Unbounce submissions

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.

Typeform

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

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.

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.

How to automatically add leads from forms to your database or spreadsheet

Related articles

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