I’ve gotten Google Calendar Event Reader nodes to write events from multiple calendars using Google Sheets Writer. I also have a template of formulas on a separate tab to calculate and format the Google Calendar Events properly.
The problem I am having is being able to clear all the rows of the same Google Sheet tab that is being written to (while keeping the header data of that tab, and the tab with template formulas) before the calendar events are extracted to the Google Sheet.
Happy to provide any more detail if needed, thanks.
Hey @anu_singla! If you’re reporting an issue with a flow or an error in a run, please include the run link and make sure it’s shareable so we can take a look.
Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={{your_run_id}}&workbook_id={{workbook_id}}
Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
Provide details about the issue—more context helps us troubleshoot faster.
Hey @anu_singla – At the moment you can’t clear or delete rows. The best option would be to use the Create New Sheet option under Show more Options on the node. This creates a new spreadsheet with the same headers.
I’ve created a template that formats the information in the Google Sheet. Is there a way to create a new sheet the way you mentioned, and add Google Sheet formulas to it?
Yeah, I think this should work — you can format the data with the formula before writing to the sheet. Any data passed using a Google Sheet formula will show up as the formula on the sheet itself.
For example, if I pass this to the sheet writer node, it’ll hyperlink it: =HYPERLINK("https://gumloop.com/", "Gumloop")
