[ACTION] Add a new row in Google Sheets

[dylburger]

I'd like a Pipedream action to let me easily add a new row to a Google spreadsheet. This action should wrap the API endpoint for appending to a sheet, giving me a friendly interface for adding the row to the target spreadsheet / sheet.

[adamd]

Yes! APIs aren't always good at exposing use cases, so it sometimes takes multiple calls or re-organizing the data in a confusing way. It would be great to see Pipedream expose the underlying user actions.

[dylburger]

@adamd would love your feedback on the new "Add a Row to a Sheet" action:

Take a look at this workflow for an example — I'm adding a new row with the name and title of the HTTP request body.

Once you add the spreadsheet ID and the sheet name, you can click the "Send Test Event" button to send an example HTTP request that I've configured and it'll add a row with that data:

Would love to hear any feedback you have.

Still working on that trigger for new rows, too. Updates coming soon!

[jiceorange]

Thanks for the action, it's useful. However, I find that I added: insertDataOption: "INSERT_ROWS" to params. This did two things:

1. If there were not enough rows in a sheet, the action would fail. This inserts a new row instead.
2. There was a race condition; two async rows added at same time would sometimes overwrite (last one wins). Inserting prevents that.

I'm new to Pipedream, so this was useful. However, I find the UI in the setps.add_new_row_to_sheet difficult to use. For Row params, if I try to change a row, I seem to end up deleting a row and then need to re-add. And, there is no way to add except after the last row param. Maybe this is a general issue and not unique to this action.