Versions Compared

Old Version 3

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column

 Submissions can be saved directly into Google Sheets. For complete details on using Google Drive with please see Connection to Google.

This tutorial will walk you through the steps for connecting a form to a google sheet. By the end of this tutorial you will have a form that creates a new row in your google sheet each time someone submits your form.

We'll take you through the process from the start -- logging into a google account and creating a spreadsheet; to the end-- using your form and seeing the submission written to your Google Sheet.

Column
width240px

On this page:

Table of Contents
maxLevel1
 

 

Prerequisites

...

  • Enter your Google account username and the access token for your account, Click the login button. If you see the message "Invalid Credentials" click here for the solution.
  • A Spreadsheet dropdown appears listing all the spreadsheets in your Google account
  • Select the Birthday List 
  • Finally select the worksheet Sheet1
  • Click Finish on the Wizard

     

  • Set the Share permission for your Google Sheet to public.

...

Test the form 

Now you are ready to test your form. Click the  save and exit icon in the form designer. You’re back to the Forms Home Page. Click the “Test” button.

...

Submit the form and look at your Birthday List spreadsheet again.

Image RemovedImage Added

Congratulations! 

...