# Apps Script

**URL:** <https://community.glideapps.com/t/apps-script/28848>\
**Category:** Ask for Help\
**Created:** [July 8, 2021, 8:25am UTC](https://community.glideapps.com/t/apps-script/28848 "2021-07-08T08:25:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [July 8, 2021, 8:25am UTC](https://community.glideapps.com/t/apps-script/28848/1 "2021-07-08T08:25:25Z")

</div>

Hi,

I need your help.  
This script below is for export purpose to PDF format but only one sheet.  
How to make it multiple sheet?  
I believe it related to “gid” but i’m not sure the format.

> **Summary**
>
> const exportOptions =
> 
> ```
> 'exportFormat=pdf&format=pdf' + // export as pdf
> 
> '&size=A4' + // paper size letter / You can use A4 or legal
> 
> '&portrait=true' + // orientation portal, use false for landscape
> 
> '&fitw=true' + // fit to page width false, to get the actual size
> 
> '&sheetnames=false&printtitle=false' + // hide optional headers and footers
> 
> '&pagenumbers=false&gridlines=false' + // hide page numbers and gridlines
> 
> '&fzr=true' + // do not repeat row headers (frozen rows) on each page
> 
> '&gid=101637384'; // the sheet's Id. Change it to your sheet ID.
> 
> ```

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [July 8, 2021, 11:52am UTC](https://community.glideapps.com/t/apps-script/28848/2 "2021-07-08T11:52:17Z")

</div>

See if this can help you:

> **[Print Google Sheets as PDF with Apps Script | xFanatical](https://xfanatical.com/blog/print-google-sheet-as-pdf-using-apps-script/)**
>
> Learn how to convert a Google Sheet to PDF using Apps Script. Print and save your Sheets as professional-looking PDF documents effortlessly.

Or mine tutorial to create a PDF document using external services:

> [@How to generate a PDF in pdfmonkey.io via Zapier](https://community.glideapps.com/t/how-to-generate-a-pdf-in-pdfmonkey-io-via-zapier/27325):
>
> I want to premise that the method I am presenting here is currently the only one that I have tested and for which I am sure that it works. It is likely that there are better methods than mine; I think that through webhook it is possible to do better than this but I have not yet had the opportunity to experience it. In any case, if you want to know how to generate a PDF from your sheet which is the datasource of your Glide application, this tutorial will probably be useful for you. So let’s ge…
