Smartsheet
Google Forms + Smartsheet Integration
Create records in Smartsheet on Google Form submission
How to integrate your Google Form with Smartsheet?
You can integrate Google Forms with Smartsheet using Form Director. Form Director enables you to connect Google Forms with Smartsheet, allowing you to create records based on form responses.
When a user submits a Google Form, the responses are automatically sent to Smartsheet, where records are created accordingly.
What is Form Director?
Form Director is a Google Workspace add-on that directs data submitted from Google Forms to applications like Google Docs, Forms, Sheets, Contacts, Calendar, Tasks, Email, Trello, Slack, QuickBooks etc.
Installation:
It is available in the Google workspace Marketplace.
Please check installation instructions to install the add-on.
What is Smartsheet?
Smartsheet is a work management platform you need to move from idea to impact - fast. Easy-To-Configure Rules. Automate Work Processes. Products: Automate Work Processes, Deploy With Confidence, Apps And Integrations, Work At Scale With Control Center.
Google Forms to Smartsheet: Use Case(s)
> Create record in Smartsheet on Google Form Submission
Google Forms
Create record on Form Submit
Form Director
Smartsheet
Demo Video: How to insert rows into Smartsheets on Google Form Submission?
Setting up Smartsheet in Form Director
Choose Smartsheet from the list of apps
Name your service
Choose Create record under services
Configuring Smartsheet
Click on "Connect to Smartsheet"
Click on Allow to allow Form Director to access your Smartsheet account for reading your basic info and sheets also to write to sheets
If SmartSheet is connected successfully the following screen appears.
Choose the sheet you need to send Form data.
Mapping
Click Setup Mapping and setup the mapping.
Mapping of form fields to that of app fields is to be done in order to create asana card on form submission.
Click on the add icon to add new mapping
Once you have done mapping you can save the service
Note : Mapping should be done between app field and form field of same type.
Notification
Notify your audience with success or error notifications.
Switch on Send Email to send email during execution.
Email Template
Send your own customized emails on form submission to your audience.
Attachment
Click Pick Drive Files to attach files to Email.
Add attachments from previous service results.
Select the required service result.
Finish setting up
Save service
You are all set to send form data to smartsheet on your Google Form submission
See Smartsheet
You can see a new record in your smartsheet
