Question

Google Sheets to HubDB Using Custom Request in Webhook

  • 12 February 2024
  • 5 replies
  • 43 views

Hello! I’m working on automating a webinar listing page for my company using a HubDB table. I need to set up a Zap that triggers when a new row gets added to a Google Sheet and feed that to the HubDB table using the HubDB API using this endpoint:

curl --request POST \
  --url https://api.hubapi.com/cms/v3/hubdb/tables//rows \
  --header 'authorization: Bearer YOUR_ACCESS_TOKEN' \
  --header 'content-type: application/json' \
  --data '{
  "values": {
    "webinar_name": "[Webinar Name Token]",
  }
}’

I am currently able to configure the Zap so that it creates a new row in the HubDB table. However, no data from the Google Sheet comes over and the created row in the table is blank. I’ve tried using the data tokens and static values and can’t seem to get it to work. Any idea what I might be doing wrong here? Attached screenshot of my Zap configuration (minus my API key header).


5 replies

Userlevel 7
Badge +14

Hi @nrivera8108 

The screenshots did not upload.

 

Hi @Troy Tessalone! Here it is

Userlevel 7
Badge +14

@nrivera8108 

Can you link to the app API docs that you referenced to configure the Zap step?

@Troy Tessalone here it is: https://developers.hubspot.com/docs/api/cms/hubdb

The endpoint I’m using here is “Add a new row to a table”

Userlevel 7
Badge +14

@nrivera8108 

The current version of the HubSpot API is v3, but the screenshot shows v2.

 

 

Make sure you have an Authorization Header set as that’s not visible in your Zap step screenshot.

 

Try using the fields in the HubSpot API docs to configure your JSON correctly for the body data as it relates to the “values”.

 

Reply