Hey there, I created a dashboard using Typeform data stored in a Google Spreadsheet through the API.
I noticed that the "Submitted At" field retrieved via the API is +7 hours ahead of my timezone, so I tried to fix this by creating a new calculated field with the following formula:
"DATETIME_SUB(
PARSE_DATETIME("%d/%m/%Y %H:%M:%S", Submitted At),
INTERVAL 7 HOUR
)"
However, when I tried to use this field to create charts, I encountered the following error:
"Looker Studio cannot connect to your data set.
The data from the underlying Google Sheet could not be retrieved.
error ID: 7c43b14a"
I have already tried the following:
1. Check Google Sheets Access
2. Re-authenticate Google Sheets Data Source
3. Verify Google Sheet Link
4. Check Data Source Configuration
5. Share the Google Sheet
6. Clear Cache
Unfortunately, none of these solutions worked.
Does anyone know how to solve this?
Thanks in advance!
LinkedIn
Twitter
