Notifications
Clear all
Topic starter
I'm utilizing the 'Create Spreadsheet row' event to add data to a Google Sheet. It seems to be inserting a new row, which is disrupting cell references on other tabs. My goal is to append the new row to the existing blank row at the bottom of the sheet, rather than inserting a new blank row. Is this achievable with callin.io?
Posted : 04/08/2025 8:31 am
Hi
callin.io action steps:
- Action: GSheet - Lookup Row
- Need to search by a column with a value
- e.g. USED = YES / NO
- Need to search by a column with a value
- Action: GSheet - Update Row
- Map the Row/ID from the previous step
Posted : 28/05/2025 12:00 am
Topic starter
Thank you for the prompt reply! In the Lookup Row action within callin.io, is there a method to find the first empty cell at the end of the spreadsheet? As the Lookup Value is mandatory, I'm uncertain how to search for the first blank entry.
Posted : 28/05/2025 12:00 am
To look up an existing row, you need to specify a lookup column and a lookup value.
EXAMPLE
- Lookup Column: USED
- Lookup Value: NO
Then, when updating the GSheet row, change USED to YES.
Posted : 28/05/2025 12:00 am
Topic starter
Thanks! That lookup and update method was successful. Hopefully, in the future, we'll see an improvement allowing updates into the first empty row, which would let us bypass the lookup.
Posted : 30/05/2025 12:00 am
That’s amazing! A huge thanks to Troy for pointing you in the right direction!
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Posted : 02/06/2025 12:00 am