# Export Google Sheet to DF

**URL:** <https://community.make.com/t/export-google-sheet-to-df/91858>\
**Category:** Questions\
**Tags:** http, api\
**Created:** [September 13, 2025, 11:03am UTC](https://community.make.com/t/export-google-sheet-to-df/91858 "2025-09-13T11:03:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Josua\_Papalampros](https://avatars.discourse-cdn.com/v4/letter/j/9de053/32.png) [@Josua\_Papalampros](https://community.make.com/u/Josua_Papalampros)\
**Post date:** [September 13, 2025, 11:03am UTC](https://community.make.com/t/export-google-sheet-to-df/91858/1 "2025-09-13T11:03:30Z")

</div>

**Subject:** Issue exporting Google Sheets as PDF (range A1:J until lastRow+2)

Hello Make Support Team,

I’m trying to automate exporting a Google Sheet as a **PDF** in a scenario.

Requirements:

- Only export **columns A–J**

- Only up to a **dynamic row number = LastrowNumber + 2** (I calculate LastrowNumber earlier in the scenario).

What I’ve tried so far:

- **HTTP → Make a request** with the URL:

- **Custom OAuth2 connection** with Client ID / Client Secret and redirect URI → Authentication works, but the export still returns the login page.

- **Google Drive → Make an API Call (files.export)** → works, but it only exports the **entire spreadsheet**. Unfortunately, I cannot specify a `range` or `gid` there.

My questions:

- What is the **correct way in Make** to export only a specific range of a Google Sheet (e.g. `Allgaier!A1:J384`) as PDF?

- Can this be done via **Google Sheets → Make an API Call** , or is the HTTP module with a special configuration the only option?

- How can I make sure the **OAuth token** is passed correctly? (Currently I always get 401 Unauthorized.)

Thank you very much for your support!

Best regards,

Toni

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [December 12, 2025, 12:12pm UTC](https://community.make.com/t/export-google-sheet-to-df/91858/4 "2025-12-12T12:12:04Z")

</div>