Google Sheets + Kit
Update Google Sheets properties when new subscribers join via Kit forms
When a new subscriber fills out a form in Kit, update your Google Sheets with their details instantly. This workflow keeps your sheet properties up to date with the most recent form responses, ensuring you have access to the freshest data at all times. It's an efficient method to maintain your contact records and stay on top of your subscriber base. This seamless linkage between Kit and Google Sheets saves you time and effort in data entry.
When a new subscriber fills out a form in Kit, update your Google Sheets with their details instantly. This workflow keeps your sheet properties up to date with the most recent form responses, ensuring you have access to the freshest data at all times. It's an efficient method to maintain your contact records and stay on top of your subscriber base. This seamless linkage between Kit and Google Sheets saves you time and effort in data entry.
- When this happens...
New Form SubscriberTriggers when a subscription occurs on a specific form.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Change Sheet PropertiesUpdate Google Sheets properties like frozen rows/columns, sheet position, and visibility settings.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Unsubscribe
Triggers when a subscriber unsubscribes from your emails.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Transaction IDRequired
EmailRequired
Subtotal
Tax
Shipping
Discount
Total
Currency
Transaction Time
Status
Product nameRequired
Product IDRequired
Product SKU
Product price
Product quantity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TagRequired
EmailRequired
First Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Purchase
Triggers when a new purchase is added to your account.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Subscriber
Triggers when a new subscriber is confirmed within your account (has completed any applicable double opt-ins).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.FormRequired
EmailRequired
First Name
Optin to Sequence
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SequenceRequired
EmailRequired
First Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscriber IDRequired
TagRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email AddressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
About Kit
Related categories
Related Zap Templates
- Add subscribers to Kit from new Google Sheets spreadsheets rows
- Create Google Sheet rows for new tagged subscribers in Kit
- Add Kit subscribers to forms for new or updated rows in a Google Sheet
- Add ConvertKit subscribers from a Google Sheets spreadsheet
- Tag Kit subscribers when new rows appear in Google Sheets spreadsheets
- Add Kit subscribers to sequences for new rows in Google Sheets
- Create Google Sheet rows for new subscribers in Kit
- Add tags to Kit subscribers for new or updated rows in a Google Sheet
- Create Google Sheets rows for new Kit form subscribers
- Add Kit subscribers to sequences for new or updated Google Sheet rows
- Create Google Sheets spreadsheet rows from new tag subscribers in Kit
- Add Tags to Kit Subscribers from New Google Sheets Rows (Team Drive)
- Add new Google Sheets spreadsheet rows to a Kit sequence as subscribers
- Log new Kit purchases as rows in Google Sheets
- Create or update Kit purchases from new Google Sheets rows
- Add new Kit sequence subscribers to Google Sheets rows
- Update Google Sheets rows with new Kit form subscribers
- Add new Kit sequence subscribers to a Google Sheets spreadsheet as rows
- Add new Kit subscribers to Google Sheets as multiple rows
- Add new Google Sheets spreadsheet rows to Kit as subscribers
- Create multiple spreadsheet rows in Google Sheets for new form subscribers in Kit
- Update Kit subscribers with tags from new or updated Google Sheets rows
- Create multiple rows in Google Sheets for every new tag subscriber in Kit
- Create spreadsheet rows in Google Sheets for new unsubscribes in Kit
- Update Google Sheets rows with new Kit subscribers
- Add subscribers to sequence in Kit for new or updated rows in Google Sheets team drive
- Capture new Kit form subscribers with custom actions in Google Sheets
- Add Kit subscribers from new or updated rows in Google Sheets team drive
- Remove tags from Kit subscribers when new rows are added to Google Sheets
- Update Google Sheets rows with new Kit form subscribers
- Create or update ConvertKit purchases from new or updated rows in Google Sheets
- Remove tags from Kit subscribers for new or updated rows in Google Sheets
- Tag new Kit subscribers when a new row is added in Google Sheets
- Add new Google Sheets rows to Kit as subscribers
- Add new Kit subscribers to Google Sheets as rows
- Add new or updated Google Sheets rows to Kit as subscribers
- Create spreadsheet rows in Google Sheets for new tag subscribers in Kit
- Add new or updated Google Sheets rows to Kit as sequence subscribers
- Add new or updated Google Sheets rows to Kit as subscribers in a sequence
- Add tag to Kit subscribers from new Google Sheets rows
- Add new or updated Google Sheets rows to Kit as form subscribers
- Add tags to Kit subscribers from new or updated rows in Google Sheets
- Clear Google Sheets rows for every new Kit form subscriber
- Create top rows in Google Sheets for new Kit subscribers
- Update Google Sheets rows each time new subscribers are added to tags in Kit
- Create new Google Sheets rows for new Kit form subscribers
Related Zap Templates
- Add subscribers to Kit from new Google Sheets spreadsheets rows
- Add ConvertKit subscribers from a Google Sheets spreadsheet
- Create Google Sheet rows for new subscribers in Kit
- Add Kit subscribers to sequences for new or updated Google Sheet rows
- Add new Google Sheets spreadsheet rows to a Kit sequence as subscribers
- Add new Kit sequence subscribers to Google Sheets rows
- Add new Kit subscribers to Google Sheets as multiple rows
- Update Kit subscribers with tags from new or updated Google Sheets rows
- Update Google Sheets rows with new Kit subscribers
- Add Kit subscribers from new or updated rows in Google Sheets team drive
- Create or update ConvertKit purchases from new or updated rows in Google Sheets
- Add new Google Sheets rows to Kit as subscribers
- Create spreadsheet rows in Google Sheets for new tag subscribers in Kit
- Add tag to Kit subscribers from new Google Sheets rows
- Clear Google Sheets rows for every new Kit form subscriber
- Create new Google Sheets rows for new Kit form subscribers
- Create Google Sheet rows for new tagged subscribers in Kit
- Tag Kit subscribers when new rows appear in Google Sheets spreadsheets
- Add tags to Kit subscribers for new or updated rows in a Google Sheet
- Create Google Sheets spreadsheet rows from new tag subscribers in Kit
- Log new Kit purchases as rows in Google Sheets
- Update Google Sheets rows with new Kit form subscribers
- Add new Google Sheets spreadsheet rows to Kit as subscribers
- Create multiple rows in Google Sheets for every new tag subscriber in Kit
- Add subscribers to sequence in Kit for new or updated rows in Google Sheets team drive
- Remove tags from Kit subscribers when new rows are added to Google Sheets
- Remove tags from Kit subscribers for new or updated rows in Google Sheets
- Add new Kit subscribers to Google Sheets as rows
- Add new or updated Google Sheets rows to Kit as sequence subscribers
- Add new or updated Google Sheets rows to Kit as form subscribers
- Create top rows in Google Sheets for new Kit subscribers
- Add Kit subscribers to forms for new or updated rows in a Google Sheet
- Add Kit subscribers to sequences for new rows in Google Sheets
- Create Google Sheets rows for new Kit form subscribers
- Add Tags to Kit Subscribers from New Google Sheets Rows (Team Drive)
- Create or update Kit purchases from new Google Sheets rows
- Add new Kit sequence subscribers to a Google Sheets spreadsheet as rows
- Create multiple spreadsheet rows in Google Sheets for new form subscribers in Kit
- Create spreadsheet rows in Google Sheets for new unsubscribes in Kit
- Capture new Kit form subscribers with custom actions in Google Sheets
- Update Google Sheets rows with new Kit form subscribers
- Tag new Kit subscribers when a new row is added in Google Sheets
- Add new or updated Google Sheets rows to Kit as subscribers
- Add new or updated Google Sheets rows to Kit as subscribers in a sequence
- Add tags to Kit subscribers from new or updated rows in Google Sheets
- Update Google Sheets rows each time new subscribers are added to tags in Kit