ConditionalVisibility

new-products-promo

Google Sheets Macros

Google Sheets Macro Recorder Tool

Save Google Sheets Macro

Google Sheets Macro Gif

Google Sheets add custom shortcut

Macro keyboard shortcuts

Edit Google Sheets Macro

App tutorials

google-sheets-macros primary img

Google Sheets

By recording your steps into a macro, you can teach Google Sheets how to do them at the click of a button, and never have to manually do it again.

How to automate Google Sheets with macros—no coding required

Far too often, it goes like this: You download data from your apps—your PayPal transaction data, say, or an exported email list from your old newsletter app—and open it in a spreadsheet. 

How to Automate Google Sheets With Macros—No Coding Required

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

Custom Actions (Beta)

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

API Request (Beta)

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)

Collect new Typeform responses as rows on Google Sheets

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

Add new Facebook Lead Ads leads to rows on Google Sheets

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

Save new Gmail emails matching certain traits to a Google Spreadsheet

Trying to bulk create Trello cards? Or perhaps you have a Google Form that should create Trello cards.

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.

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.

Find Card

Finds a member in your Trello organization by name.

Find Member

Find or Create Label

Find or Create List on a Board

Find or Create Checklist

Finds or creates a specific organization board.

Find or Create Board

Finds or creates a specific organization card.

Find or Create Card

Create Checklist Item in Card

Add Member to Board

Create Board

Adds a new card on a specific board and list.

Create Card

Archive Card

Adds one or more attachments to a specific card.

Add Attachment to Card

Adds an existing label to a specific card.

Add Label to Card

Moves a specific card to a list on a specific board.

Move Card to List

Adds one or more members to a specific card.

Add Members to Card

Update a card's name, description, due date, or position in list.

Update Card

Adds a new (or existing) checklist to a card.

Add Checklist to Card

Closes a board without permanently deleting it.

Close Board

Create Comment

Completes an existing checklist item in a card.

Complete Checklist Item in Card

Copy Board

Delete Checklist in Card

Create List

Remove Label From Card

Create Trello cards from new rows on Google Sheets

This integration makes it easy to trigger an email via Gmail for updates in a Google Spreadsheet. You can trigger an email based on any update or specific updates to a certain column. Get step-by-step directions in our 

How to Automate Google Sheets With Macros—No Coding Required

Related articles

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