Need help connecting spreadsheet with shortcut using google web app URL
I tried building a credit card expense logger with shortcuts that update my expenses to a spreadsheet. Hit a wall now, unable to understand how to navigate.
Expected Flow
Action button triggers, ask multiple inputs like card, amount, description, payment mode and store it on a spreadsheet.
I built things at shortcut and I made a Google web app url script to connect shortcut and spreadsheet
But when I test run the flow, input data are not getting populated on the spreadsheet.
- Input data collection is working fine.
- Manually hardcoded the script web app url and tested in safari that’s populating the spreadsheet.
Only when I try the shortcut flow it’s not working.
Btw - I use get content url action block for this spreadsheet link. Attached a screenshot of the same.
I don’t have coding knowledge so I really appreciate if someone can help me troubleshoot this.
I’m also okay with any easy route to do this.