Skip to main content

Notifications

Power Automate - Building Flows
Answered

Download a google sheets worksheet as pdf

Posted on by 11

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:

andsic_0-1680349417323.png

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

  • Verified answer
    andsic Profile Picture
    andsic 11 on at
    Re: Download a google sheets worksheet as pdf

    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

     

  • Re: Download a google sheets worksheet as pdf

    Hi @andsic ,

     

    I made a sample for you.

    vxiaochenmsft_0-1680486023205.png

    vxiaochenmsft_1-1680486049536.png

    vxiaochenmsft_2-1680486072009.png

    vxiaochenmsft_3-1680486093651.png

    vxiaochenmsft_4-1680486106164.png

     

    Best Regards,

    Wearsky

  • andsic Profile Picture
    andsic 11 on at
    Re: Download a google sheets worksheet as pdf

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,473

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,659

Leaderboard