Prerequisites

• To connect Retail Revenue data via Google Sheets, please ensure you have access to the Retail Revenue template (link HERE) and the ability to share the sheet with an external service account. If you have any trouble completing these steps, your Prescient CSM is available to assist you.

Expected Table Schema

Our integration expects access to a single table that aggregates your key daily offline metrics. This table should follow the schema below:

Setup Instructions

To enable Retail Revenue data ingestion, please follow the steps below:

1. Download the Retail Revenue Template

• Download and use the official Prescient Retail Revenue Google Sheet template:

📥 Retail Revenue Template https://docs.google.com/spreadsheets/d/17xT_HuKM3_v81M13Lc4NDdPZ5ANfikk_AvW4y6k0WLY/edit?gid=0#gid=0

2. Prepare Your Google Sheet

Fill in your Retail Revenue data using the provided template.

• Ensure all required columns are populated
• Data should be aggregated at a daily or weekly level (Data should be pulled from a Monday - Sunday start if at the weekly level)
• Create a named range that includes all data rows (e.g., RetailRevenueData)
• Note: The template includes a pre-configured named range by default

If needed, see Create & use named ranges in Google Sheets

3. Share the Sheet

Share the Google Sheet with Prescient’s service account:

• Permission level: Viewer
• Email address: google-sheet-integration@prescient-ai-production.iam.gserviceaccount.com

4. Enter Sheet URL in Prescient

Copy the full URL of your Google Sheet and paste it into the Sheet URL field in the Prescient setup form.

5. Validate and Select Named Range

In Prescient:

• Click Find Sheet to validate access
• Select the appropriate named range from the dropdown

6. Save & Test

Click Save & Test to complete setup and confirm successful ingestion.

Tips:

• If validation fails, double-check that:
• The sheet is shared with the correct email
• The full Google Sheet URL was used
• The named range fully covers your data