Google Sheets + Jotform
Assign prefilled forms in Jotform from new Google Sheets rows
Whenever you add a new contact to a Google Sheets row, they will be invited to complete a prefilled Jotform form.
Whenever you add a new contact to a Google Sheets row, they will be invited to complete a prefilled Jotform form.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Assign Prefilled FormInvite assignees to complete your pre-populated form
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo 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.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 foundSelect a formRequired
Asignee emailRequired
Invitation Message
Assignee Permission
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select a formRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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 foundSelect a formRequired
Assignee emailRequired
Invitation Message
Prefilled Field Permissions
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.
About Google Sheets
Related categories
About Jotform
Related categories
Related Zap Templates
- Save new JotForm responses as Google Sheets rows
- Add new Jotform submissions to a Google Sheets spreadsheet
- Add new Jotform signed documents to Google Sheets as spreadsheet rows
- Update Google Sheets rows with new Jotform submissions
- Update Google Sheets spreadsheet rows when there are new form submissions in JotForm
- Enrich Jotform form data with Lead Score by Zapier and log it in a Google Sheet
- Create Google Sheet worksheets for new Jotform submissions
- Update Google Sheets rows with new Jotform submissions
- Create worksheets in Google Sheets for new submissions in Jotform
- Add new Jotform submissions to Google Sheets as spreadsheet rows
- Create columns in Google Sheets for new Jotform submissions
- Create copied worksheets in Google Sheets for new Jotform submissions
- Create new Jotform forms from new Google Sheets spreadsheets
- "create copies of worksheets in Google Sheets for every new submission in Jotform"
- Assign prefilled forms in Jotform for new or updated rows in Google Sheets
- Assign forms in Jotform for new or updated rows in Google Sheets
- Create new Jotform submissions from new Google Sheets rows
- Create new Jotform submissions from new or updated rows in Google Sheets
- Create Jotform submissions from new or updated rows in Google Sheets team drive
- Assign forms in Jotform whenever there's a new spreadsheet row in Google Sheets
- Clear Google Sheets rows when new submissions are received in Jotform
- Update spreadsheet rows in Google Sheets with new submissions from Jotform
- Create new Google Sheets rows at the top for every new Jotform submission
- Assign forms in Jotform for every new or updated row in Google Sheets team drive
- Create Jotform submissions from new Google Sheets spreadsheets
- Create spreadsheets in Google Sheets for each new signed document in Jotform
- Update Google Sheets properties with each new Jotform submission
- "rename Google Sheets each time a new submission is created in Jotform"
Related Zap Templates
- Save new JotForm responses as Google Sheets rows
- Update Google Sheets rows with new Jotform submissions
- Create Google Sheet worksheets for new Jotform submissions
- Add new Jotform submissions to Google Sheets as spreadsheet rows
- Create new Jotform forms from new Google Sheets spreadsheets
- Assign forms in Jotform for new or updated rows in Google Sheets
- Create Jotform submissions from new or updated rows in Google Sheets team drive
- Update spreadsheet rows in Google Sheets with new submissions from Jotform
- Create Jotform submissions from new Google Sheets spreadsheets
- "rename Google Sheets each time a new submission is created in Jotform"
- Add new Jotform submissions to a Google Sheets spreadsheet
- Update Google Sheets spreadsheet rows when there are new form submissions in JotForm
- Update Google Sheets rows with new Jotform submissions
- Create columns in Google Sheets for new Jotform submissions
- "create copies of worksheets in Google Sheets for every new submission in Jotform"
- Add new Jotform signed documents to Google Sheets as spreadsheet rows
- Enrich Jotform form data with Lead Score by Zapier and log it in a Google Sheet
- Create worksheets in Google Sheets for new submissions in Jotform
- Create copied worksheets in Google Sheets for new Jotform submissions
- Assign prefilled forms in Jotform for new or updated rows in Google Sheets