Hello Community!
I have encountered a problem with my site using Google Sheets and Zapier.
On my website, users can apply to projects, and my idea is that every time a project is created it would create a new google sheet spreadsheet, so far that works. But when I tried to send the application of the user to the specific project I cannot link it with the project. I have tried storing the value of the id of the spreadsheet in Zapier but when I call it it does not let me store the values into the columns that I want.
Is there another possible way to achieve this?