Audeza Doc Merge

How to send donation receipts from a Google Form

A Google Forms™ donation form records who gave and how much. It doesn't take the payment, and it can't send a proper receipt. Its built-in "response receipt" is a copy of the answers, with no organization name and none of the wording a tax receipt needs. Here's how to send each donor a PDF receipt once their gift has arrived.

1. Build the form

Ask for what the receipt needs to show:

Then link the form to a spreadsheet: Responses > Link to Sheets.

2. Set up the responses sheet

Three small changes make the receipts come out right.

If you number receipts, add a column headed "Receipt No" and put this formula in its row 2. It fills every row, including responses that arrive later:

=ARRAYFORMULA(IF(A2:A="", "", "R-" & TEXT(ROW(A2:A) - 1, "0000")))

Use one formula for the whole column, not one per row. Form responses insert new rows, and a formula copied down by hand doesn't follow them.

3. Write the receipt template

A Google Docs™ file with your letterhead and tags where each donor's details go. For a US charity, the IRS requires a written acknowledgment for any single gift of $250 or more, and it has to state the organization's name, the amount of a cash gift, and whether you gave anything in return. A template that covers that:

Donation receipt <<Receipt No>>

Riverside Food Bank, a 501(c)(3) organization, EIN 00-0000000, gratefully acknowledges a cash gift of <<Amount>> from <<Full name>>, received on <<Timestamp>> by <<Payment method>>.

No goods or services were provided in exchange for this contribution.

Swap in your own name and tax ID. If donors get something in return, like a dinner ticket, the receipt has to describe it and give a good-faith estimate of its value; that needs its own wording. Rules differ outside the US, so check what your country's tax office asks for. The IRS details are in its page on written acknowledgments.

If the gift date and the form date differ, for example a check that arrives a week later, add a "Date received" column next to "Received" and use <<Date received>> in the template instead of the timestamp.

4. Send a receipt once the gift arrives

  1. In the responses spreadsheet, open Extensions > Audeza Doc Merge > Open and click New merge job.
  2. Pick the "Form Responses 1" tab, your receipt template, and a Drive folder for the PDFs.
  3. Set the file name to Receipt <<Receipt No>> - <<Full name>>, so the folder sorts by number.
  4. Under Only some rows, choose Received, is, Yes.
  5. Turn on Email each document. Send to <<Email Address>> with a subject like Your receipt from Riverside Food Bank and a short thank-you note that uses <<Full name>>.
  6. Click Test with first row. You get a PDF named "TEST - ..." and no email goes out. Check it, delete it, then click Save.

From then on, typing "Yes" in the Received column is the only step. The hourly run picks up the row, saves the PDF to your folder, emails it to the donor, and writes "Merged" with the time next to it. Your spreadsheet becomes the list of who has a receipt and who doesn't. To fix a receipt and resend it, correct the row, delete the old PDF and clear the row's status cell.

Year-end statements

Some donors want one statement for the year instead of a receipt per gift. In January, add a tab with one row per donor and their email, and total each donor's gifts with SUMIF on the responses tab. Then create a second merge job with a statement template, point it at that tab, and click Merge now.

What it costs

Doc Merge is free for 50 receipts a month, with every feature on. Pro is $49 a year for unlimited. Email limits come from Google: about 100 recipients a day on a free Gmail™ account and 1,500 on Google Workspace. After a big appeal, any receipts past the limit wait and go out the next day on their own. The add-on can open only the template and folder you pick, and your donor data stays in your Google account.