How to Integrate with Google Spreadsheets (Automatic Output) (PROFESSIONAL Plan and Above)

How to automatically output data obtained by formrun to Google Spreadsheet.

Export to Google Sheets (Automatic)

This is an export method available only with the PROFESSIONAL plan.

1. Open the list page

2. Click on the "(Export) icon at the top right of the list page."

image-03

3. From the settings page "External Integration Settings > Google Sheets Integration (Automatic Export to Linked Sheets)," click "Connect."

4. Select the Google account to connect

5. From the settings page "External Integration Settings > Google Sheets Integration (Automatic Export to Linked Sheets)," click "View Spreadsheet."

image-02

After configuring the automatic export settings, data submitted after that will be automatically accumulated in the same sheet.

Please note that only entries that occur after setting up automatic export will be exported to Google Sheets.


Also, regarding the timing of integration with Google Sheets, it will occur only when an entry is made.

Therefore, data changed on cards will not be automatically reflected on Google Sheets, so please be aware of this.

※ The "Card URL" field is only output when "Google Sheets (Manual Export)" is used.
 

If you would like to know how form submission data is exported when using the Google Sheets automatic export feature, please refer to the capture of the sample form and the form output to Google Sheets below.

  • Sample form image

img3

  • Capture when the above sample form is automatically exported to Google Sheets

image-02