Smartsheet

Google Forms + Smartsheet Integration

Create records in Smartsheet on Google Form submission

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