Introduction
If you're managing data in Google Sheets and need to generate clean, professional PDFs—like invoices, reports, or receipts—the PDF Maker web app provides a fast and user-friendly solution. Unlike traditional add-ons, this method works directly within the PDF Maker platform, allowing you to import Google Sheet data, map fields, and generate custom PDFs in just a few steps. This tutorial will walk you through how to use Google Sheets with the PDF Maker app to streamline your document workflows.
Step-by-Step Guide: Connect Google Sheets to the PDF Maker App
1. Open your PDF Maker app and Go to the Settings
2. Click on Sign in with Google
3. Link your Google account. This step is important because it lets PDF Maker connect with your Google Sheets.
So make sure you choose the right Google account—the one where your Sheet is stored.
4. The Google account is successfully connected.
5. Click on create.
6. Type Template Name
7. Click on Google Sheets
8. Click on Next
9. Click on Select...
10. Click on Invoice Data. ( Choose the sheet in which you have the data )
11. Click on Select
12. Click on Sheet1
13. Choose your primary Column.
14. Click on Select...
15. Click on Invoice - 1ejzIkZrH03mNR447mNwMNUFmelVvrxlSs3bC5fSj4Uk
16. Click on Select
17. Click on Next
18. Click on Next
19. That's how the Template will look like.
20. I have created my template.
21. Click on copy Text.
22. Now add the relevant placeholder in the respective places.
23. After adding all the placeholders, your template is ready.
24. Click on Save.
25. Click on Template Saved Successfully
26. Now go back and Click on Generate.
27. Check all the rows for which you want to create the PDFs.
28. Click on Generate PDFs
29. Click on PDF.pdf
30. And this is how the final output will look like.
FAQs About Using Google Sheets with the PDF Maker App
Q1: How is using Google Sheets with the PDF Maker app different from using the add-on?
Ans: The PDF Maker app provides a centralized dashboard with more advanced customization and template options. You can connect your Google Sheets once, map fields, and generate or automate PDFs without accessing Google Sheets each time.
Q2: What kind of documents can I create using my Google Sheet data?
Ans: You can create invoices, reports, certificates, receipts, quotes, and any other structured document that can be populated using spreadsheet data.
Q3: Do I need to upload the sheet or does the PDF Maker app connect directly to my Google Sheets?
Ans: The PDF Maker app allows you to connect your Google account and fetch data directly from your Sheets. No need for manual uploads—just authenticate and select the required sheet.
Q4: Can I map specific columns from the sheet to a PDF template?
Ans: Yes, once your Google Sheet is connected, you can map specific columns to placeholders in your PDF template. This allows precise control over what data appears and where it’s placed in the final PDF.
Q5: Is the data secure when connecting Google Sheets with the PDF Maker app?
Ans: Yes, the PDF Maker app uses secure Google OAuth authentication. It only accesses the sheets you authorize and doesn’t store your data beyond what is needed for PDF generation.
Conclusion
Using Google Sheets with the PDF Maker app gives you more flexibility, control, and automation than the traditional add-on method. It's perfect for businesses, educators, and professionals who want to generate documents at scale—without leaving the browser. Connect your sheet, map your fields, and generate your first PDF in minutes.