Two scripts, one custom menu
For the technically curious: here's what's actually wired up behind the scenes.
SendEmail.gs - The Engine
runs when "Send Email" is clicked
Reads the Configuration
Pulls every row's sheet name, range, orientation, recipient, subject, body, and sender.
Exports each range as PDF
Builds the Google Sheets export URL with the right page settings - portrait or landscape, fitted to the range.
Skips duplicate PDFs
Compares a hash of the new file against any existing PDF with the same name. Identical files don't get re-saved.
Saves to a dedicated folder
Creates (or finds) a Drive folder named "Sent PDF Files" so reports never get lost in the root.
Sends with custom sender name
Uses GmailApp with the sender name from the config - so the recipient sees "MARIA," not the script owner.
Retries on rate limits
If Gmail returns a 429, the script waits and retries up to 10 times with exponential backoff.
Menu.gs - Custom Menu
runs when the spreadsheet opens
Builds a menu on open
An onOpen trigger adds a custom "Menu" to the Sheets toolbar every time the file is opened.
Lists all sheet names
One click auto-populates the Configuration sheet with every tab in the file - no manual typing.
One-click navigation
Each menu item activates a specific tab - no scrolling through twenty tabs to find one.
Triggers Send Email
The same menu has the "Send Email" button that kicks off the engine.