ConditionalVisibility

new-products-promo

Shawn Harris, Director of Product Services, HBO

Alan Penn, the COO of Around The Clock Alert (ATC Alert)

Owen Colwell, VP of Growth at POSH

Megan Belair, Editorial Business Manager, Delish

Piers Fawkes, President, PSFK

Tommy Walker, The Content Studio 

Taysa Mohler headshot

Zapier initiatives

No Code Contest 2023 Hero Image

Earlier this year, we launched our second annual No-Code Day Contest and asked you to submit your favorite no-code projects. 

A roundup of innovative submissions from Zapier's 2023 No-Code Day Contest

Keeping data up to date in your spreadsheets and databases can be tough. This Zap can save you from copying and pasting data back and forth, though. Set it up, and whenever you add or update a new row in your Google Sheets spreadsheet, Zapier will automatically copy the data and use it to update a specified row in your Airtable database. It's a simple way to keep your data up-to-date!

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 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)

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

Update Airtable records with newly-updated rows in Google Sheets spreadsheets

Create a back up for your database records with this Airtable to Google Sheets automation. Once set up, each time a new record is added to a selected view in Airtable, Zapier will automatically add a new row into your selected Google Sheets spreadsheet. Prevent losing data when you create copies, and use this integration as an easy way to export Airtable database info to a spreadsheet.

Add new Airtable records in views to Google Sheets

Manage your daily tasks when you incorporate this Google Sheets to Asana automation. Set it up, and each time a row is updated in a selected Google Sheets spreadsheet, Zapier will create a new task in Asana. Stay focused when you use this integration.

Asana is a leading work management platform that helps teams orchestrate their work, from daily tasks to strategic initiatives. With Asana, organizations have a living system of clarity where everyone can see, discuss, and execute their team’s priorities.

Asana

Triggered when a task within a project, or any project within a workspace, is marked as completed. Does not trigger on completed subtasks.

Completed Task

Triggered when a Task is added to a Project.

New Task

Triggers when a new Comment is added to a Task in Asana.

New Comment on a Task

New Project

New Story

New Subtask

Triggers when a Subtask is completed in Asana.

New Completed Subtask

New Tag Created

Triggers when an attachment is added to a task.

New Attachment Added to Task

Triggers when a Task is moved to a section.

Task Moved to Section

Triggered when you add a new task to a project.

New Task in Project

Tag Added to Task

New Team

Triggered when a Task is updated in a Project.

Updated Task

Triggered when a task in a project is updated.

Updated Task in Project

New User

Triggered when you add a new workspace/organization.

New Workspace/Organization

Find Project

Finds an existing section within a workspace project.

Find Section in Project

Finds an existing task within a workspace project(s).

Find Task in Project

Find Task by ID

Finds a task in a workspace. Supports custom fields. Available only to premium Asana users.

A roundup of innovative submissions from Zapier's 2023 No-Code Day Contest

Related articles

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