Smartsheet

What is Form Director?

Form Director is a G Suite 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 G Suite Marketplace and Chrome Web Store. 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.

Use Case(s)

> Create record in Smartsheet on Google Form Submission

Google Forms

Create record on Form Submit

Form Director

Smartsheet

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

  • Choose the sheet you need to send Form data

Mapping

Steps for mapping from field with Slack fields

  • Click on setup mapping
  • Choose the form field
  • choose the app field
  • click save

Finish setting up

  • Save service

You are all set to send form data to smartsheet on your Google Form submission

Submit the Form

Submit the Google Form

See Smartsheet

You can see a new record in your smartsheet