Skip to main content
Question

Google Sheets to HubDB Using Custom Request in Webhook

  • February 12, 2024
  • 5 replies
  • 141 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).

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @nrivera8108 

The screenshots did not upload.


  • Author
  • New
  • 2 replies
  • February 12, 2024

 

Hi @Troy Tessalone! Here it is


Troy Tessalone
Forum|alt.badge.img+14

@nrivera8108 

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


  • Author
  • New
  • 2 replies
  • February 12, 2024

@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”


Troy Tessalone
Forum|alt.badge.img+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”.