This article provides an overview to get started with the Google Sheets connector in Peliqan. Please contact support if you have any additional questions or remarks.
In peliqan, go to Connections, click on Add new. Find Google Sheets in the list and select it. Click on the Connect button. This will open Google Sheets and allow you to authorize access for Peliqan. Copy the id of the Google Sheet file from the URL and paste it in the connect form.
Once the authorization is done, you will return to Peliqan.
Wait a few minutes for the data to start syncing. Now you can view your Google Sheets data in tables in Peliqan’s built-in data warehouse (or in your own DWH if you connected e.g. SQL Server, Snowflake, Redshift or BigQuery).
Select “Explore” in the left navigation pane, expand “Data warehouse” in the left tree and click on Google Sheets. All tables from Google Sheets will now be shown.
You can explore the data in the gridview, and you can write SQL queries to transform the data and to combine the data from Google Sheets with data from other sources.
If you add multiple Google Sheet connections and the pipelines run at the same time, they might hit the rate limits of the Google Sheets API. In that case, you can use a Python script to schedule the Google Sheets pipelines one after the other, and disable the Scheduler on the connection card itself. Example script:
pq.run_pipeline(connection_name = 'Google Sheets 1', is_async = False, timeout=3600)
pq.run_pipeline(connection_name = 'Google Sheets 2', is_async = False, timeout=3600)