I want to update a google sheet when someone subscribes to Action Network.
I have got Make to connect to both the Action Network webhook and the google sheet.
However the data from the json is not put into the sheet - a row is added and the date is put in row column G, and the fixed text into column H, but columns A to F are empty.
The input bundle appears to be empty?
The output bundle is
[
{
"osdi:submission": {
"created_date": "2024-02-20T00:45:12Z",
"modified_date": "2024-02-20T00:45:12Z",
"identifiers": [
"action_network:xxxxxx"
],
"person": {
"created_date": "2024-02-20T00:45:12Z",
"modified_date": "2024-02-20T00:46:18Z",
"family_name": "Wood",
"given_name": "Chris",
"postal_addresses": [
{
"primary": true,
"locality": "Exeter",
"region": "England",
"postal_code": "xxx xxx",
"country": "GB",
"location": {
"latitude": xxxxx,
"longitude": xxxxx,
"accuracy": "Approximate"
}
}
],
"email_addresses": [
{
"primary": true,
"address": "chris@fakeemail2.co.uk",
"status": "subscribed"
}
],
"phone_numbers": [
{
"primary": true,
"number": "xxxxxxxx",
"number_type": "Mobile"
}
],
"custom_fields": {
"@!@tag@!@xxxxx": "Exeter_CallMe",
"GDPR_consent": "GDPR_Policy_V3"
},
"languages_spoken": [
"en"
]
},
"add_tags": [
"Exeter_CallMe"
],
"action_network:referrer_data": {
"source": "widget",
"website": "xxxxxxxx"
},
"_links": {
"self": {
"href": "https://actionnetwork.org/api/v2/forms/xxxxxx"
},
"osdi:form": {
"href": "https://actionnetwork.org/api/v2/formsxxxxxxx"
},
"osdi:person": {
"href": "https://actionnetwork.org/api/v2/people/xxxxx"
}
}
},
"action_network:sponsor": {
"title": "xxxxx",
"url": "https://actionnetwork.org/groups/xxxxxx"
},
"idempotency_key": "xxxxxx"
}
]
Thanks in advance…