Are you sure you want to report the post shown below? This will send an email to the ATVO administrators.
Please include a short reason for reporting.
Users reporting for no reason may be locked out.
Post
Posted by Admin
on
ATVO Theme 2023 updates: This version is testing support for Google Sheets as spreadsheets. Instead of browsing for a local csv or Excel file, you can now copy/paste a Google Sheet URL into the filepath bar. Please let us know if you see any issues with either Google Sheets or regular CSV / Excel files.
Access: the Google Sheet file must be accessible by the public, or you must share it with our ATVO service account. You can do that by sharing the file with the following email address: atvo-service@atvo-373210.iam.gserviceaccount.com
You must copy/paste the exact URL that you find in your browser address bar into the ATVO 'Filepath or Google Sheet url' bar, including the sheet ID and the "gid" portion (which links to the right sheet in case there are multiple in one file).
Updates to your online sheet will not automatically reflect in your theme. You will have to manually refresh the sheet from the settings to reload it.
Especially if you use multiple Google Sheets, you may run into rate limiting which delays the downloading by several seconds. Sheets are loaded in the background to avoid locking ATVO while the sheets download. The file will eventually download if you give it enough time, or it will timeout and give an error. Unfortunately we cannot impact the rather strict rate limiting of the Google API so some patience is required.