Google Sheets

Connect Google Sheets to Smore and data will be automatically recorded in the spreadsheet whenever a response is received. Check the responses in Google Sheets and analyze your data thoroughly.

‍

How to integrate

1. [Publishing] tab - [Integration] section - [Google Sheets Connect] click

‍

2. Select the account you want to connect to.

‍

3. Select the sheet where you want to enter data and you’re done!! 🎉

To a new spreadsheet: [To a new spreadsheet] click > Name your new spreadsheet > A new sheet is created in your google drive

The connected spreadsheet is created in [My Drive], not [Shared Drive]! When a new sheet is created, search the name of the new sheet in [My Drive] and transfer it to the company’s shared drive. 

‍

To an existing spreadsheet: [To an existing spreadsheet]] click> Enter the link to an existing spreadsheet

‍

Integration Completed

In the connected sheet, all types of components except the ‘Plain Text’ type are recorded. 😀

‍‍

Precautions after Integration

Content modification after integration

• If a component is changed

If you already have responses collected in your sheet before you change a component, a new column is created for the modified component, and new responses to that modified component are recorded in the new column.‍

• If order of components is changed

If you change the order of components, the column order of responses already recorded in the sheet will not automatically change. If you want to make changes in the sheet, you can manually move the entire column within the sheet.‍

• If a component is deleted

Even if you delete a component, any responses to that deleted component that have already been recorded in your sheet are NOT deleted! If you want to delete the responses as well, please delete the entire column manually.

‍

Connected sheet modification

• CAN be donesome text
  • Add data manually
  • Hide columns for components before final modification
  • Edit existing data
  • Delete existing data
  • Add a lookup formula to another sheet that references the connected sheet
  • Change the connected sheet name
  • Change the tab name within the connected sheet
  • Use filters on the column headers
  • Change column header text
  • Change column order
  • Change row order
  • Add a new component/question to your Smore content
  • Delete an existing question in your Smore content
  • Edit existing choices text in your Smore content
  • Change the order of existing components/questions in your Smore content

‍

• CANNOT be done (*Sheet connection can be disconnected!)some text
  • Delete the tab within the connected sheet
  • Delete the connected sheet
  • Move the sheet to a folder that is not owned by the Google account used when setting up the connection in Google Drive (The file must be located in a folder that you own to be connected with Smore)
  • Add calculations/formulas directly to the connected sheet some text
    • Add checkbox type column
  • Delete Smore App from your Google account settings
  • Delete your Google account

‍

For the stability of Google sheet connection, it is recommended to make a copy of your connected sheet and modify it or use calculations/formulas within it rather than modifying the connected sheet directly.

‍

FAQ
‍

[To an existing spreadsheet] button is not appearing

Due to Google’s API call limitations, the button will not appear if you try to connect your Smore content that has already collected more than 10,000 responses.

• Therefore, you must proceed with  [To a new spreadsheet]. Then data will be recorded from the response after the connection.
• Existing data can be checked in Smore’s Analytics

‍

Connected was made, but the sheet is empty

The header of the sheet is created when the first response comes in. When no responses have been made after the connection, a blank sheet is normal :)

‍

Quotation marks (‘) appear in responses to Number/ Rating / Slider type components

This is when Google sheet automatically adds quotation marks (‘) to cells containing numbers. You can remove the marks using the following method

• Select the entire column and choose ‘Format’ from the menu
• Click ‘Number’ and click 'Custom number format’
• Choose the format you want to use and click ‘Apply’

‍

It seems some responses were recorded twice

Due to the nature of Google API, a response can sometimes be recorded more than once in the sheet. Please refer to this document to remove duplicate responses.

‍