Post New Record Creations to Google Sheets

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
I am trying to populate new form entries in my Database to a Google Spreadsheet in real time.  How can I do this using either webhooks or another feature in QB?
Photo of Monster

Monster

  • 72 Points

Posted 1 month ago

  • 0
  • 1
If anything native in Quick Base is going to work - you might be able to do a POST webhook and do an append API call to your google sheet. I found this from a minute or two of digging. 

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append

If you want to go that route - I'd recommend testing it out using Postman, as you're going to have a really hard time trying to actually do your Webhook and get any kind of debugging info back in Quick Base. This will give you better access to the response trying your POST there and then copying your info into a Quick Base Webhook. 

Alternatively - Workato has an out of the box Google Sheets connector that makes this really easy to work with too.

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base