Adding Google Sheets as a Raw Data Source

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.

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.

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.

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.

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.

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.