"400: INVALID_ARGUMENT - Unable to parse range:......."

Hey guys. I need some help. My workflow does not work.

The workflow is as follows:

  1. Watches for a new event created in Eventbrite. Multiple events, each sent as a bundle.

  2. List any new attendees to that event.

  3. Creates a new Sheet in Google Sheets.

  4. Add a row of Headers.

  5. Add the details of the attendees to the Sheet.

Error displayed is the “400: INVALID_ARGUMENT - Unable to parse range: ‘Attendance List for [Collection]’!A1”

I have been told the following: Split the scenario into two scenarios and attach a HTTP to one and WEBHOOK to the other. They suggested adding an iterator or a time delay, or change the name of the sheet.

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of six modules in this order:

This is just an example. Your final solution may or may not look like this depending on your requirements.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Hey Sam,

I got it. I made it work, but it is in this order:

The problem right now is that every time it runs, a NEW spreadsheet is created. What I want is the previously-created spreadsheet to be UPDATED with new attendees and new details. Any ideas how?