Hi,

I have a list of emails, attendees and response status in JSON format from a google calendar trigger.

This is what I’m trying to do :

 

Create a table using input data as columns "displayName" "email" and "responseStatus" . Add a column "guest_type" as the first column
Exclude input data where "email" has domain example.com
Add value to "guest_type" for each row according to the following strict order: 
'main_guest' IF input data "displayName" has a value
'guest_1' IF another row exists
'guest_2' IF another row exists
etc
Output individual items with the following values from matching column and row
Item 'main_guest_email' . Value=column 'email' row 'main_guest' where input data "displayName" exists
Item 'guest_1_email' Value=column 'email' row 'guest_1' when another row is available
keep adding incremental items up to guest_5
Item 'main_guest_responseStatus' Value=column 'responseStatus' row 'main_guest' where input data "displayName" exists
Item 'guest1_responseStatus' Value=column 'responseStatus' row 'guest_1' when another row is available
keep adding incremental items up to guest_5

I have no coding skills, I tried with Phyton AI Code , but I didn’t get the expected output. Is coding the only solution or has Zapier any tool to do this filtering / outputs.