Copying and pasting to and from the first available row of a Google Sheet without coding

[tmk118]

I have a Voiceflow chatbot that captures dates from an outside source and passes them to Voiceflow by temporarily pasting the dates onto a Google Sheet.

Right now, I have the chatbot users choose dates on an Elementor form, which then get pasted to a Google Sheet using a webhook scenario.

Once Voiceflow captures the dates, a second webhook scenario deletes the data for the next use.

This works great when testing the prototype, but I don’t think it will work if more than one user is saving dates to the chatbot at the same time.

I’m wondering what the best scenario is to use here?

Is there a scenario where I can store those dates on the next available row if another user already has dates on the first row and then delete both rows after use?

Example:

Row 1 is the header

User 1 has dates entered on Row 2

User 2 would have dates entered on Row 3

After the scenarios are run for User 1, Row 2 is deleted

User 3 dates are entered on Row 2

After the scenarios are run for User 2, Row 3 is deleted

If

User 3 finishes both scenarios before User 4 enters dates, the dates entered by User 4 would be placed on Row 2.

If

User 3 does not finish both scenarios before User 4 enters dates, the dates entered by User 4 would be placed on Row 3

I know I can add a new row, or even a new sheet, I’m wondering how to tell the second scenario to delete the new row or new sheet when done if I don’t know what the row number will be or the sheet name will be?

[L_Duperval]

Instead of deleting a row, would it be feasible to add a “complete” flag in a column?

If not, maybe consider using something like Airtable, Firebase, or another database that is specifically designed for multi-user access.

L

[tmk118]

Thank you so much for the advice. I didn’t know Airtable had that capability. I’ll try Airtable.