Google Sheets + Data Feeds!

July 12, 2024

What is a Data Feed?

A data feed is a snap shot of your data that is generated from the Planning Center API and reformatted so you can have raw data to build your own reports, analytics, and dashboards. It is meant to be the ultimate tool for accessing your raw data in a format that is build for data nerds.

Google Sheets Integration

I've built an easy to use google sheets integration that allows you pull a data feed directly into google sheets.

  1. Add the add-on in Google Sheets from the Google Marketplace.
  2. Add your API Key from pcochef.
  3. On a blank worksheet select the data feed you want to connect to that worksheet
  4. Select "Import Data" and the current data feed will be added to the sheet. The data in the sheet will be overwritten with the current data feed.

“PCO Chef's use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy, including the Limited Use requirements.”

Data Feeds Documentation

You can find Data Feeds Documentation here.