Google Sheets + Ycode

Add new Ycode database entries to Google Sheets rows

No more hassle with manually importing and exporting data to keep your database and sheets up-to-date. With this handy Zapier template, each new Ycode database entry (yours, or for example, data from a website visitor through a form) will be automatically added to the Google spreadsheet you select.

When this happens...
New Database Entry
Triggers when a new database entry occurs.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Database Entry
Triggers when a new database entry occurs.
Trigger
Instant
Updated Database Entry
Triggers when a database entry is updated.
Trigger
Instant
Create New Database Entry
Creates a new entry in selected database
Action
Write
Create New Published Database Entry
Creates a new entry in selected database and shows it on the published site
Action
Write
Update Database Entry
Updates the values of specific fields in database entry
Action
Write

Update Published Database Entry
Updates the values of specific fields for a database entry and shows it on the published site
Action
Write
Search Database Entry
Searches database entries from selected database
Action
Search

New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Trigger
Scheduled

Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action