Ultimate goal is to get a summary of Google spreadsheet data sent to my email. Modules used are drive, set variable, open ai and gmail.
Sequence as follows:
Watch for file upload in drive folder - convert spreadsheet to json- pass json through open ai to summarise - that summary gets sent to my email.
The issue is that different spreadsheets will trigger the automation to begin with and the json will always be different. I can’t seem to figure out what to change for it to work the way I want to.
Any ideas?