e55657 bc43518b18c9491dab9e434b352bfbac~mv2

This post was originally published by Kalani Tissot on his blog and has been reposted here with his permission.

I’ve scoured the web, and there is no up-to-date guide on connecting popular donation processors like ActBlue or Numero to a Google Sheet. Let’s change that.

Here’s how to integrate these three applications using Zapier and automate part of your fundraising workflow. (You can sign up for a free Zapier trial here)

Connecting ActBlue to a Google Sheet:

file
e55657 ed1016e718434dc1bdcb28d639b6bf51~mv2

Zapier Share link: https://zapier.com/shared/42a1cbd50f751c599432665874367f785793b2ad

Zapier:

  1. Create a new Zap.
  2. For your trigger, use “Webhooks by Zapier.”
  3. For the trigger event, select “Catch Hook.”
  4. Copy the custom Webhook URL and hit continue (You can ignore the silent mode and “pick off a child key”).

ActBlue WebHook:

  1. Log in to your ActBlue Account.
  2. Go to Webhook Integrations in the Tools section.
  3. Click on the green “Request a New Webhook” box.
  4. For type, select “ActBlue Default.”
  5. Paste your Zapier Webhook link into the endpoint URL.
  6. Create a credentials log in (this won’t matter for this).
  7. Submit your request and wait up to 24 hours for ActBlue support to approve the webhook.

Google Sheets:

  1. Add the following columns to your respective worksheet: First Name, Last Name, Contribution Page, Amount, Date, Address, City, State, ZIP, Email, Phone Number, Occupation, and Employer.

Zapier:

  1. Test the Webhook trigger, and a recent donation should come up.
  2. For step two, select Google Sheets and connect your Google account.
  3. Select your Google drive and the spreadsheet that you just created.
  4. Map each webhook value to its respective column.
  5. Test your action (Zapier should send your most recent donation to the Google Sheet).

That’s it! Moving forward, this Zap will automatically send all of your ActBlue donations to the Google Sheet of your choice.

Automatically adding Numero donations to a Google Sheet:

file
e55657 3f4fe4203608405794404bc81e3e11f8~mv2

Zapier Share Link: https://zapier.com/shared/ebc13d21d3934cad26edf8e126e18d3033a4fa22

Numero doesn’t have any webhooks available for donations, so we have to collect donation data via another means — email parsing. Parsing is a type of software that allows you to collect & capture data from received emails.

file
e55657 5d7ddf505b204e7ab077f47b0c0b6c17~mv2

Go to parser.zapier.com and log in via your Zapier account. Then, create a new email address to receive Numero contribution alerts.

In Numero, go to “Manage Team” and click on “Add a new Team Member.” Add in your new Zapier Email Parsing address as a new team member. Then, your new Zapier email parsing account will receive an invitation inviting them to join Numero. On an incognito window browser, log into your email parsing account and click the link to join. Then in Numero, under your user settings, set up notifications for contributions of $1 or more.

Zapier:

  1. Create a new Zap.
  2. For your trigger, use “Email Parsing by Zapier” and select the trigger event as “New Email.”
  3. Connect your email parsing account to Zapier and run a test. The initial email inviting you to join Numero should pop up.

Email Parser by Zapier:

  1. Now, wait until a Numero contribution is made. If you wish to speed this up, make a $3 Numero contribution to send an email notification to your parser account.
  2. Once an email notification for a contribution has been received, we now have to create a new Template for the email parser to extract data.

Here’s the template that I use for my Zap. I’ve blacked out specific donor data for privacy.

file
e55657 56de0aeb80b841928fb0d44ce38e4f15~mv2

The curly brackets, {data}, represent which data strings will be extracted from your email alert. Here is what my output looks like:

file
e55657 f072bbb0e6fd4e9f98fdf5660ebd0276~mv2

Zapier:

  1. Now that your email parser is set up head back to Zapier and test your email parser trigger. Your most recent contribution on Numero should come up with a parse outlet line containing your extracted data.

Google Sheets:

  1. Create a new Google spreadsheet (or worksheet in your Finance Plan) and add in the following columns: Date & Time, Amount, Name, Phone Number, Email, Address, Employer & Occupation, and Donation Form.

Zapier:

  1. For your first action, select Google Sheets and choose “Create Spreadsheet Row in Google Sheets.”
  2. Connect your account and select the respective Google spreadsheet & worksheet.

Here’s what your action step should look like.

file
e55657 7c7d51c7bb5d45ac8e0f478b1adc62f8~mv2

Zapier:

  1. Test your action on Zapier, and this Zap should add a new spreadsheet row to your Google Sheet!

Now moving forward, every time you receive a Numero contribution, your respective Google Sheet will automatically be updated with new donation data.

Additional Integrations:

Use Slack? Add a step to either of these Zaps and send Slack notifications when contributions are processed.

Want to send an email from your candidate’s Gmail account thanking each donor? Easy, add in Gmail as a third action step on your Zap and add parse output or webhook data to customize each email.

Do you use Action Network for your mass emails? Set up a third action and automatically add each new Numero donor to your email list.

If you use Zapier for any other integrations, send me a note at Kalani@TissotSolutions.com. I’d love to hear about how others are using tech tools like this.

Kalani Tissot

Kalani Tissot is a political fundraiser and consultant based in Las Vegas, Nevada.

Ever since he volunteered on his first campaign in college, Kalani has been on a mission to help Democrats win up and down the ballot across the country.

In 2018, Kalani drove four days straight from Washington State to Florida to work on a Congressional campaign and help Democrats take back the House. After that, he served as the Finance Director for the South Carolina Democratic Party, where he raised over $1.2 million and organized a 1,100 person dinner that raised over $250,000 in one night. Then, Kalani moved to Nevada to work as the Finance Director for Congressman Steven Horsford, where they raised nearly $3.5 million for his competitive re-election campaign. Now, Kalani works with a great group of candidates who are all preparing for 2022 and beyond.

No sheet? How is that even possible?
Booking component arrowBooking component arrow mobile
Headshot of Eric Taylor
Eric Taylor
Numero Chief of Staff
Before Numero
Cory 2020 logoDCCC logoDemocratic National Committee logo

Talk with Eric Today!

In a free personalized zoom call, Eric will show you how to use Numero to:
Light purple tick icon
Dedupe donors instantly
Light purple tick icon
Instantly build a list of the best prospects for your candidate
Light purple tick icon
Find max-out donors hiding amongst your contacts.
Light purple tick icon
Stress-free demo session. No sales pressure, guaranteed.
Eric’s next AVAILABLE time is
Tuesday, July 25th at 9:00am CST
Book it Now
Find next available time
Down arrow icon

Meet Numero

The all-in-one donor database and call time app
Table background image
Pink arrowPink arrow for table in mobile view
The most downloaded call time app ever
5x
Our nearest competitor
Numero logo
ngpvan logo
Pingdex logo
Calltime logo
Numero border designNgpvan border designPingdex border designCalltime border design
Table heading gradient
Star Ratings
Last Updated
Critical icon
Updated apps are critical for security
No Saudi Government Investors
Eyes icon
Numero logo
5.0
Star icon
2
Days ago
US flag icon
Numero is built, secured, & maintained entirely by a team of American citizens based in the U.S.
ngpvan logo
3.5
Star icon
307
Days ago
SA flag iconNews article for pricing table
Kingdom of Saudi Arabia
Sovereign Wealth Fund
Investors in NGP (twice) 👀
Eyes icon
Pingdex logo
4.8
Star icon
105
Days ago
US flag icon
Calltime logo
3.7
Star icon
927
Days ago
IN flag icon
Outsource their jobs & access to your data
to India.
*Number of downloads publicly available data from Google

See Numero Now!

Curious to see what makes Numero special? See our live demo right now.
Play icon
See Live Demo
Call to action card background image
CTA Card Image mobile

Have a call with Eric!

He’s been in your shoes as a campaign staffer and is here to help you individually.
Book a personalized demo
Headshot of Eric Taylor