About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How can I generate a pdf of one Google Sheet worksheet (not the entire file) to send by email
Best answer

How can I generate a pdf of one Google Sheet worksheet (not the entire file) to send by email

  • 4 January 2023
  • 6 replies
  • 308 views
K
Userlevel 1

Hello Zapier Community,

 

I need some help to achieve my goal ! ;) I hope you can guide me to getting this work ! ** fingers crossed **

 

I have a Google Form that my leads complete.

The GForms fill automatically a row of information in a first GSheet (responses from GForms)

My Zapier triggers when the first GSheet has a new row and it starts by coping that row of information into another GSheet which with loads of differents calculations brings up on one specific Worksheet a report.

Up to this all is OK ;) 


I now need to create a pdf of the specific Worksheet and send it out by email to the person who filled in the GForms.


This is where I block.


I have seen how to generate a pdf of my entire Spreadsheet but I don’t need to send out all my calculations etc… out. I just want the final report to be sent out.


I saw how I could “publish to the web” in pdf and send that link by email but my page settings go out the window and if by chance I have 2 answers at the same time I am not confidend that it would send the right info to the right person…

 

I have tried to copy the worksheet but it takes the formulas and so I loose everything on the report. Is there a way of copy/paste with format & values?

 

If someone can highlight me on generating this pdf (if possible without any extra apps) I would be gratefull!

 

Thank you very much !

 

Kim

icon

Best answer by Troy Tessalone 4 January 2023, 18:00

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Kim KeepCalm.Biz 

Good question.

 

Check out this related topic:

 

If you need to, hide the worksheet tabs that are not relevant.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
K
Userlevel 1

Hi @Troy Tessalone 

Thank you for your quick response !

I thought we had got the right solution by hidding the tabs I didn’t need but unfortunately, the file that calculates being the base file and google giving a link to the base file and not a direct pdf, if I come back to my link later in my email and not to the pdf I would have downloaded on the moment (if no-one else has done the GForms in between) I will have the latests leads info… :’( 

What could I do to go round that do you think?
Thanks for you precious help !

 

Troy Tessalone
Userlevel 7
Badge +14

@Kim KeepCalm.Biz 

We’d need more visual context to better understand what is configured and what is not working. (screenshots)

Make sure your desired worksheet tab to get as a PDF is the first worksheet tab even with the hidden worksheet tabs.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
K
Userlevel 1

@Troy Tessalone

Globally it works it is just that as the GForms GSheet answers sends one line of data into my “report maker” which is a Google Sheet and that Zapier sends out in the email le pdf export link, if another lead has generated a report the previous one sees his report updated to the new data, because le email sends a Sheet link to export in pdf and not directly a pdf.

I guess the trick will be for each lead that fills in the GForms I ask Zapier to create the hole database per lead and send out a unique link per lead. Because at the moment le link is unique for all my leads…


What do you think?

Troy Tessalone
Userlevel 7
Badge +14

@Kim KeepCalm.Biz 

Did you follow this guide?

https://community.zapier.com/show%2Dtell%2D5/how%2Dto%2Dget%2Dthe%2Dpdf%2Dversion%2Dof%2Da%2Dgdrive%2Dfile%2Dgdocs%2Dgsheets%2Dgslides%2D13619

 

If you use the correct link to export the PDF format?

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
K
Userlevel 1

@Troy Tessalone 

Yes I did indeed ! But finally doing one file per lead works better and comes out with a proper pdf that I can name as I want too. I did exactly the same except that the first time gmail refused that I had the pdf address like an attachement, and now is OK with it. Maybe something to do with the sharing property of the file it self.
The whole zap looks like this:

 

and the email result :


Thank you very much for your guidance and support (I discovered the file sharing preference and find file thanks to you and the forum) 🙏🙏🙏

I have just lost the emojis in the pdf and a little moving of the layout that I will sort out, nothing too bad ! Better done than perfect !
Now I just need to make all the zap properly clean with the official emails etc… :) Whoop Whoop !

Have a great evening ! 🎉🎉🎉

Terms & Conditions