How can we help you?

How to Add Google Sheets as a Source

Adding Google Sheets as a Raw Data Source

Connect to Google Sheets

Here, you can connect your raw data source to Read/See by clicking the "Add Source" button and choosing "Google Sheets."

If you need guidance on the type of data that should be connected, you can download a sample file using the "Download Sample" button.

Add Source

Click the "Connect" button. You will be prompted to allow your Google account to grant Read/See access to your data sources.

This step is necessary for establishing a secure connection between your raw data and the Read/See dashboard.

Source Data Configuration

You will then need to configure your source based on your specific needs. This includes specifying:

  • File Name: The name of your Google Sheets file in your Google Drive.
  • Connect as a: Whether you want to connect the file as a profile or an event.
  • Sheet of Profile/Event Properties: The sheet within the file that contains the profile or event properties.
  • Where Your Data Starts: The starting point of your data within the sheet.

Select the checkbox if you also want to connect the file as profile/event properties.

Once you have filled in all of the required fields, click the "Connect" button to complete this step.

Define your data

To properly set up your data, you'll need to specify the distinct ID for each profile, which will be used to uniquely identify each profile.

You'll also need to define the field names for the other properties that make up each profile.

When you’re done, click the “Data Preview” button to view the data and make sure it's correctly formatted before moving on.

Check your data before finish it

Before finishing the connection process, make sure to thoroughly review your data to ensure it's all correct and properly formatted.

If everything looks good, then click the “Finish” button to complete the connection of your raw data source to Read/See.

Your data source successfully added

Great job! Your data source has been successfully added to Read/See.

You can now use the data to create insightful reports and track your metrics over time. You can now easily visualize and analyze your data to make informed decisions and grow your business.

With this integration, you have the power to turn your raw data into actionable insights, making data-driven decision-making more accessible and efficient.

Was this article helpful?

Logo ReadSee

Representative:

Singapore
READSEE TECH PTE LTD
20A Tanjong Pagar Road 088443

Find us on

All Rights Reserved © readsee.io