No personal information is stored about your donors within Google Sheets. This is by design to keep everything as anonymous as possible when viewing and sharing data.
You are required to be a Giving Admin for this connector to work.
The PCO Giving connector supports downloading your donations in a transaction list. If your donors give to more than one fund in a transaction you'll see this broken into separate lines.


Enable this module within the Settings screen of the sidebar. You can follow the instructions in step 2 of the configuration guide.

Ideas to Use

These are just some ideas and by no means the only way to use this information. If you find new and creative ways to look at your data we would love to hear from you! Email us at [email protected]
  • Viewing your giving by month or week
  • Calculating the total fees
  • Combining this data with People data to understand giving based on a profile field.
    • Giving based on age
    • Giving based on campus
  • Giving based on a list parameter.
    • You can create a list in PCO and use that as a parameter to filter gifts.

Giving Field Descriptions

Field Name
Donation ID
A unique ID that's generated per donation. There will be multiple duplicate values for a split donation.
Person ID
This is the unique value for each person assigned by PCO.
Received At
This is when the donation was marked as received. Use this as your primary date column.
True / False based on if the amount is refunded or not.
Payment Method
Card/Cash/Check/ACH. This will be how this was received into PCO"
Payment Method Type
This will show if the card was credit or debit.
Payment Channel
Showing if the gift came in through Batch or Stripe
Payment Status within PCO.
Card Brand
This is the brand of the card your donor is using.
These are the payment sources within PCO.
If you've assigned a payment a label, you'll get a list of those labels here.
Fund Name
The Fund Name this donation belongs to.
Ledger Code
This is the ledger code you've configured in PCO to represent your Chart of Accounts code.
This is the gift amount BEFORE the fee is removed.
This is the total amount for the fee
Net Amount
This is the amount after the fee is deducted.


How can I use labels?

Currently, labels are downloaded in a list into the label field on Google. If you're looking to filter based on a label with GDS we suggest adding a parameter to filter the data. Find more information on parameters in the GDS guide.


Giving Tab