Connecting Form in Blackbaud to Google Sheets

Ezra Jeter
Ezra Jeter
Second Anniversary
in Education Management APIs

Howdy! I have been tasked with connecting a response form in Blackbaud to a google sheet which will be dynamically updated. I have some questions regarding getting started? Where is the data for submissions to school forms stored ? What is the best way to go about sending get requests to this database? I am currently planning to use pipedream to connect Blackbaud and google sheets, using HTTPs webhooks as the trigger for pipedream.

Comments

  • Bryna Gleich
    Bryna Gleich Blackbaud Employee
    Tenth Anniversary Kudos 5 Name Dropper Participant

    @Ezra Jeter
    I don't think there is an endpoint specifically for individual school forms. But you can search the endpoints to double check.

    Instead, you could use a school form to update the database (such as to update phone numbers or some other field). Then use the API to get that info out of the database (such as for use in your Google sheets).

  • Stephen Boyle
    Stephen Boyle Blackbaud Employee
    Tenth Anniversary Kudos 5 Facilitator 2 Name Dropper

    @Ezra Jeter

    You have access to Advanced Lists through the API. So, you can build a list with School Form fields in it. The pull that out via GET List single.

Categories