Hello! I would like to take information in an Excel sheet and use it to create a deal in HubSpot via an API. I have the JSON example codes in HubSpot but having trouble figuring out how to write this in Excel so it recognizes the need to push data through the API to HubSpot by clicking a button on an excel worksheet.
Please let me know if there is example excel vba code that can accomplish this.
I'm not particularly familiar with excel vba code, but since our APIs only accept JSON as a data format the code would need to take your sheet and convert it to JSON before posting the data. You might instead consider using the in-app import tool to create these deals instead: