I recently started using the Zapier integration to update a google spreadsheet with new patrons, updated pledges, and deleted patrons. It’s awesome to finally be able to automate this process!
BUT, the zapier integration has access to each user’s unique Patron ID but I can’t find any way to export that so I can add it to all the Patrons I already have. It’s not a field on any of the “export as CSV” options I can find.
I would really like to use these Patron IDs to make sure any updates are done to the correct field since people sometimes change their names or update their email addresses.
Even looking up each Patron individually and doing it manually won’t work because only some patron’s pages display their ID (the ones that haven’t created a custom URL for their page).
Is there any way I can export a list of my patrons with their unique patron IDs? Thanks so much!