Set Up a Weekly Bulk PDF Export from Google Drive
Weekly reports, team updates, and recurring deliverables that need to go to PDF every Friday afternoon are a perfect fit for a scheduled Apps Script trigger. Set it up once and the export runs automatically every week, saving the PDFs to a dated folder in Drive.
Configuring a weekly trigger
In Apps Script Triggers, add a trigger for your export function, choose 'Time-driven', then 'Week timer'. Select the day of the week and approximate time. The script runs automatically at that time each week.
Archiving weekly exports
Configure the script to create a new folder each week named with the week's date. For example 'Weekly Reports 2026-03-09'. Each week's PDFs are stored in their own folder, creating an automatic versioned archive.
Weekly notification email
Add an email notification at the end of the script so you receive a confirmation each week that the export ran. Include the folder name, the file count, and any failures. This takes two lines of code and saves you from logging in to verify.
Frequently Asked Questions
What if the weekly trigger runs when I have no new documents?
The script completes without errors and converts whatever is in the folder at that time. If the folder is always current, the export always reflects the latest version.
Can I configure the weekly export to run on multiple days?
Each trigger runs once per interval. To run on two specific days per week, create two separate triggers pointing to the same function.
Ready to Try It?
Install the free Chrome extension and start converting your Google Docs to PDF in one click.
Install Free Extension