Skip to main content

Google Sheets Integration to save User data

Allows you to automatically store user data from form submissions

D
Written by Dharmik Valani
Updated over 4 months ago

Setting Up Your Google Sheet

  1. Log in to your Google Sheets account.

  2. Click on Blank Sheet to create a new spreadsheet.

  3. Rename the sheet to a relevant name (e.g., "User Submissions").

  4. Save the sheet and keep it open for later use.


Connecting Google Sheets to WeUpsell

  1. Log in to your Shopify store and navigate to the WeUpsell dashboard.

  2. Go to the Integrations section.

  3. Click on Google Sheets to initiate the connection.

  4. Enter a connection name (e.g., "test") and click Next.

  5. Google will prompt you to grant access to "aimbrill.com" for reading and writing data to your Google Sheets.

  6. Accept the permissions and sign in to your Google account.

  7. After following these steps, Google Sheets will now be connected to WeUpsell.


Adding Google Sheets to Your Widget

  1. Choose the widget where you want to save user data.

  2. Click on the Integrations section from the left-side panel.

  3. A Setup Integration popup will appear. Click on the settings icon of Google Sheets.

  4. A dialog box will open, displaying your available connections.

  5. Select the connection name you added during the Google Sheets integration (e.g., "test").

  6. Click Next.

  7. Click on Choose Sheet and select the spreadsheet where you want to save the data.

  8. Select the Worksheet (e.g., "Sheet 1") if your spreadsheet contains multiple sheets.

  9. Click Save to complete the integration.

  10. Google Sheets is now successfully linked to your widget.

  11. Click Save and Publish to activate the widget on your Shopify store.

Final Look:

By following these steps, your WeUpsell widget is now live, and user data will automatically be saved to Google Sheets upon form submission. Now you can efficiently collect and organize form submission data in Google Sheets, ensuring seamless record-keeping and data management.

Did this answer your question?