Hi all,
I would like to ask how to read the previous versions of a Google Spreadsheet? I have no problem of connecting Google Spreadsheet and reading the current sheet.
Please let me know if you have any suggestions. Much appreciated!!!
Hello @doris.l!
I believe that to access such data in a Retool app's table, you would need to make a custom query request to the Google Sheets API to get past/previous versions of a specific sheet.
You can ask around on the Google Sheets forum to see if anyone else has implemented a similar solution for accessing previous versions of a sheet via an API request here as I do not believe Retool has that functionality built in.
After doing some Googling around I found some posts in Stack Overflow of people trying to access previous sheet data here, it seems like the top answer might help you get closer to accessing the past versions but it does seem fairly complex process unfortunately 