Unanswered

Download a google sheets worksheet as pdf

(0) Share

Report

Posted on by andsic

Hi,

i'm trying to build a flow which downloads a google sheet worksheet as pdf, i used the "describe it do design it" option since i'm new and this is what came out:

This doesn't work as the file created will be either empty or corrupted. I tried xlsx, pfdf, even html as extension but nothing.
Could anyone please explain how to achieve this?
Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

andsic 11 on at

Like (0)

Report

Updates:
i don't think the previous is the right way, because the "table" option copies the google sheets cells.
I need that exact google spreadsheet downloaded as pdf. I tried with google drive "get file content by id" but it says: The specified file is a Google Spreadsheet and can't be downloaded.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @andsic ,

I made a sample for you.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

andsic 11 on at

Like (1)

Report

Hi Wearsky, thank you for the sample.
Since this method basically collects the row data and puts it in a pdf but i think if there are images and/or particular formatting it would get lost, I found another way:
- I used apps script to have a daily export a pdf of the sheet I needed
- I use power automate to retrieve this pdf and send it via mail

Was this reply helpful? Yes No