Discussions

Expand all | Collapse all

Post New Record Creations to Google Sheets

  • 1.  Post New Record Creations to Google Sheets

    Posted 05-10-2019 00:10
    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?


  • 2.  RE: Post New Record Creations to Google Sheets

    Bronze
    Contributor
    Posted 05-10-2019 14:09
    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