Hey all, I’m wanting to choose the Google sheet URL based off my notion database. Every item in my Notion Database has a different Google Sheet associated with it (I can’t just use one Google Sheet with many different worksheets due to the size of my Notion Database). I would like to “Read” my notion database and dynamically use the Google sheet link in that database for the “Update Google Sheet” node in Gumloop. Currently Gumloop seems to insist on me having a static link for the chosen Google Sheet.
Hey @AndrewJ! 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 @AndrewJ - Technically, yes—you can dynamically populate the Google Sheet link by exposing the link input as a dynamic under “Configure Inputs” when you hover over the node.
There are a few requirements though:
You’ll need to enter the sheet link once in the node initially so it can read the schema. After that, you can pass the link dynamically.
The spreadsheets must have the same headers (i.e., schema) for the node to work dynamically. If the headers differ, the node would need to be refreshed—which isn’t possible when passing the link dynamically. Also, the search column you’ve set would change in that case as well.