Hi again,
Thanks for your help so far, we are getting there.
The piece of the puzzle that is missing is how the data from the Events RSVP is pulled into the function,
https://www.wix.com/velo/reference/wix-events-backend/events/onrsvpcreated apparently " fires when a guest registers to a Wix event" but how do we get that payload into our function?
Note that we aren’t using forms here, we are using the Wix Events App.
If and when we get this working I’m happy to help document. The Google Sheets Integration documentation is good, but it’s very specific.
Normally I give people a chocolate frog (https://www.pinterest.com.au/pin/59602395044248530/ when they help me out, but yours might have to be virtual. 