The HubSpot Upsert Node email field suddenly doesnt work. This node uses the email field to match. It’s worked every day since I set it up and now suddenly gives me this error-
ERROR: The resource you are requesting could not be found
If I copy and paste an email into the node instead of using {{ $json[‘Email, Borrower’] }} it works.
When entering {{ $json[‘Email, Borrower’] }} into the email field it does show the correct result below it.
Why is this error all the sudden happening? I thought it might be HubSpot but wouldn’t it not work if I put an email in there? All the other nodes that get information work.
I found the issue after a testing a bit this morning. It was the Google Sheets column naming. I had the email header as “Email, Borrower”. This worked intially but when I started adding on more things I got the error that the email wasn’t being pick up. After changing the column headers to something without a comma like “EMAILB” it all worked.