Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

I have a Google Sheet the contains three worksheets. The 2nd and 3rd worksheet is used to look up values for the first worksheet. How do I generate a PDF for JUST the first worksheet? 

I have done the find a file Google Drive action but this provides a pdf of ALL THREE worksheet.

Hi @Crazy8s 

Good question.

Perhaps hide the 2 lookup worksheets.

Help topic:

 

@Troy Tessalone can you do this via Zapier as well? The sheet is created each time based on a template. 

 

 

 

@Crazy8s 

Step 7 will return a GDrive File ID and the GDrive File Name for the GSheet.

You can use the GDrive File Name to search for the File in Step 13.

Otherwise, you can use the GDrive File ID as part of a dynamic direct link to get the CSV version of the GSheet.

@Troy Tessalone I am asking specifically on how to hide the worksheets. Is that possible within Zapier?

@Crazy8s 

Why not manually hide the 2 worksheet tabs on the GSheet template being copied?

 

Yes, should be doable via the GSheets API: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/batchUpdate

 

Feedback from ChatGPT:

 

To hide a worksheet tab in Google Sheets using only HTTP REST requests without external libraries, you can use a tool like curl. You'll need to interact with the Google Sheets API directly. Here's an example of how to do this:

  1. Obtain your Google Sheets API credentials and API Key. You can follow Google's documentation to create a project in the Google Cloud Console and enable the Google Sheets API.

  2. Set your API key and spreadsheet ID:

API_KEY="YOUR_API_KEY" SPREADSHEET_ID="YOUR_SPREADSHEET_ID" SHEET_NAME="Sheet1" # Change to the name of your sheet
  1. Use curl to make an HTTP POST request to hide the sheet:
curl -X POST \ "https://sheets.googleapis.com/v4/spreadsheets/$SPREADSHEET_ID:batchUpdate" \ -H "Authorization: Bearer $API_KEY" \ -H "Content-Type: application/json" \ -d '{ "requests": s { "updateSheetProperties": { "properties": { "title": "'"$SHEET_NAME"'" }, "fields": "hidden" } } ] }'

Replace "YOUR_API_KEY", "YOUR_SPREADSHEET_ID", and "Sheet1" with your actual API key, spreadsheet ID, and sheet name.

This curl command sends an HTTP POST request to the Google Sheets API, which will hide the specified sheet in your Google Sheets document.

Terms & Conditions