n8n Workflow: Archive Last Month Invoices to Google Drive

Archive last month’s invoice tab to Google Drive—automatically

This n8n workflow automatically runs every month to copy the “last month” invoice tab from your main Google Sheets workbook into a brand-new spreadsheet stored in the matching Google Drive month folder—then renames the copied tab for accounting clarity.

What this workflow does

• Runs on a monthly schedule to keep your invoicing archive up to date with minimal manual effort.
• Finds the correct destination folder in Google Drive by searching for a folder named YYYY-MM (for example, 2026-03 for March 2026).
• Creates a new archive spreadsheet inside that folder using a Google Apps Script web app (the workflow calls the web app to receive the created spreadsheetId).
• Selects the right invoice tab in your main invoice spreadsheet by listing all tabs and keeping only the one titled in Month YYYY format (matching “last month”).
• Copies the tab into the newly created destination spreadsheet via the Google Sheets API.
• Renames the copied tab to Month YYYY - Invoices (e.g., “March 2026 - Invoices”).

Use cases

• Maintain a clean monthly invoicing archive for accounting without manually moving tabs each period.
• Keep month-by-month invoice documents separated in Google Drive for faster audits and retrieval.
• Standardize naming so finance teams can consistently locate the correct invoice dataset.

Technical details

• Integrations: Google Drive, Google Sheets, Google Apps Script web app.
• OAuth: Add Google OAuth2 credentials with access to Google Drive and Google Sheets.
• Configuration: Replace YOUR_GOOGLE_SHEET_ID in the Google Sheets API request URLs with your main invoice spreadsheet ID.
• Node stack (n8n): code, merge, filter, aggregate, sticky note, google drive.

Important: Ensure your Google Drive folders exist for each month (named YYYY-MM) and your invoice tab titles follow Month YYYY so the workflow can match last month correctly.