I need new contacts that have had an invoice sent to them be added to a Google sheet.
Currently it works by doing watch invoices, it then grabs the name, but it does not get the phone number, every time it says the phone field is empty.
Something to keep in mind is when the data comes in, it is in an array format.
“Phones”: [
{
“PhoneType”: “DEFAULT”,
“PhoneNumber”: “027…”,
“PhoneAreaCode”: “”,
“PhoneCountryCode”: “”
},
{
“PhoneType”: “DDI”,
“PhoneNumber”: “”,
“PhoneAreaCode”: “”,
“PhoneCountryCode”: “”
For some reason, Make.com just shows this as all empty.