Connect Amelia appointment booking plugin to Google sheets

[Jeffrey]

Hi there, I am going to connect Amelia appointment booking to Google sheets with Pabbly connect, my question is how I create sheets for the one appointment with more than one attendees? sending data to one sheet or split to 2 sheets, one for appointment, one for booking because that is an object array, the format looks like "Bookings 0 Id" if there are two attendees, the table header of this meta should be Booking 1 ... any number Id. If I want only one table, what I need to do? Thanks

 

[Pabblymember11]

Hey @Jeffrey

For your concern, we would recommend you to capture the webhook response in advance format by toggling the "Simple Response" button then you can capture the data in JSON array format which you can pass the Line Itemizer action step.

You can refer to the following video tutorial for your better understanding -