Trying to figure out a two step flow to essentially import a Google Sheet and then clear the rows in the sheet. I know with Airtable this is possible using the API Export destination and DELETE, but how does one do this with a Google Sheet as there isn’t an API. Thanks!
Are you trying to import the Google Sheet just to retain the headers? If so, you could always upload a CSV of the headers and not column data, and for example, overwrite your Google Sheet during each export. Does that make sense?
Hey @jp — ya that’s kind of what I was trying to do, more so just automate the clearing of a Google Sheet each night. I actually opted to just use Airtable instead as it was more straightforward given there’s an endpoint for delete records
Thanks for your help!