Connecting to overwritten Google Sheets
I am using Domo to create visualizations from a set of several Google Sheets. We have a very large data set on a site that does not have an API, so to get consistently up to date information I have a script that exports a few excel files, converts to Google Sheets and uploads to my drive account. This script runs on a daily basis. Each time the script runs, it overwrites the Sheet that was created the day prior to replace it with the updated information.
I have found that when the data sources tied to those sheets that get overwritten try to update, I get the error shown in the screenshot below. To fix the error, I just go into the details for the data source and hit save (not changing/selecting anything, just re-confirming which sheet I want to connect to).
It seems that Domo still recognizes that the sheet is under the same name, but I'm assuming the fact that it is an overwritten file there is some metadata that confuses the update process. Changing the script to append the new data rather than just uploading a new file and overwriting entirely has more technical complexity than I would prefer to take on for this.
Any help/guidance would be greatly appreciated!