Generate invoices from Google Forms automatically
Freelancers and small businesses can skip the copy-last-month’s-invoice routine. Log a finished job or an order in a Google Form; AutoDoc fills your invoice template, numbers it with the response ID, exports a PDF and emails it to the client’s address taken from the form.
| Description | Hours | Rate | Amount |
|---|---|---|---|
| {{Project}} | {{Hours}} | {{Rate}} | ${{Amount Due}} |
| Total due | ${{Amount Due}} |
See it in action
A freelancer logs a finished job in her own Google Form and the numbered invoice PDF goes straight to the client.
Watch on YouTube →How to automate invoices from Google Forms
Four steps, all inside Google Workspace. Output: PDF.
Build the form
Copy the ready-made form, or create a Google Form with questions like these. The question titles become your placeholders.
| Question title | Type | Example answer |
|---|---|---|
| Client Name | Short answer | Harbour Coffee |
| Client Email | Short answer (email) | accounts@harbourcoffee.example |
| Project | Short answer | Menu & signage redesign |
| Hours | Short answer (number) | 12 |
| Rate | Short answer | $120.00 |
| Amount Due | Short answer (number) | 1440 |
| Payment Terms | Multiple choice | 14 days |
Design the Google Docs template
Start from our Google Docs template (make a copy) or the .docx, or use your own. Type a placeholder wherever an answer should appear. It must match the question title exactly, in double braces. Built-ins such as {{_date}} and {{_responseId}} work too.
Connect it in AutoDoc
Open the form → Add-ons → AutoDoc. Pick the template and a Drive folder, choose PDF, and set the file name pattern:
Invoice {{_responseId}} - {{Client Name}}Result: Invoice 2_ABaOnud8x - Harbour Coffee.pdf
Add a conditional document (optional)
Conditions support AND / OR groups and 13 operators, including equals, contains, exists, matches regex, > and >=.
Submit, and it’s delivered
Every new response creates the document in seconds, then emails it:
Tips for invoices
- Use {{_responseId}} as the invoice number so every invoice is unique without a counter.
- Send the email to the Client Email answer (not the respondent) when you fill the form yourself.
- Add a second template, such as a payment-plan schedule, that only generates when Amount Due is over a threshold.
Frequently asked questions
How do I number invoices?
Use {{_responseId}}, which is unique for every response. Put it in the template and the file name.
Can the invoice go to the client instead of me?
Yes. In Email to respondents, set the recipient to an answer from a form question such as Client Email.
Can I use a Google Sheets invoice?
The add-on’s template picker accepts Docs, Slides and Sheets files. Put placeholders in cells.