{"product_id":"n8n-workflow-archive-last-month-invoices-to-google-drive","title":"n8n Workflow: Archive Last Month Invoices to Google Drive","description":"\u003ch3\u003eArchive last month’s invoice tab to Google Drive—automatically\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a monthly schedule\u003c\/strong\u003e to keep your invoicing archive up to date with minimal manual effort.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinds the correct destination folder\u003c\/strong\u003e in Google Drive by searching for a folder named \u003cem\u003eYYYY-MM\u003c\/em\u003e (for example, \u003cem\u003e2026-03\u003c\/em\u003e for March 2026).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a new archive spreadsheet\u003c\/strong\u003e inside that folder using a \u003cstrong\u003eGoogle Apps Script web app\u003c\/strong\u003e (the workflow calls the web app to receive the created \u003cem\u003espreadsheetId\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the right invoice tab\u003c\/strong\u003e in your main invoice spreadsheet by listing all tabs and keeping only the one titled in \u003cem\u003eMonth YYYY\u003c\/em\u003e format (matching “last month”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCopies the tab\u003c\/strong\u003e into the newly created destination spreadsheet via the Google Sheets API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRenames the copied tab\u003c\/strong\u003e to \u003cem\u003eMonth YYYY - Invoices\u003c\/em\u003e (e.g., “March 2026 - Invoices”).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain a clean monthly invoicing archive for accounting without manually moving tabs each period.\u003c\/li\u003e\n  \u003cli\u003eKeep month-by-month invoice documents separated in Google Drive for faster audits and retrieval.\u003c\/li\u003e\n  \u003cli\u003eStandardize naming so finance teams can consistently locate the correct invoice dataset.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Drive, Google Sheets, Google Apps Script web app.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOAuth:\u003c\/strong\u003e Add Google OAuth2 credentials with access to Google Drive and Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration:\u003c\/strong\u003e Replace \u003ccode\u003eYOUR_GOOGLE_SHEET_ID\u003c\/code\u003e in the Google Sheets API request URLs with your main invoice spreadsheet ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNode stack (n8n):\u003c\/strong\u003e code, merge, filter, aggregate, sticky note, google drive.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eImportant:\u003c\/strong\u003e Ensure your Google Drive folders exist for each month (named \u003cem\u003eYYYY-MM\u003c\/em\u003e) and your invoice tab titles follow \u003cem\u003eMonth YYYY\u003c\/em\u003e so the workflow can match last month correctly.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45891841392819,"sku":"N8N-18625","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/nKiLAspdRTUjHkPf6WszK_xFCVZLkQ.png?v=1787562290","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-archive-last-month-invoices-to-google-drive","provider":"N8N Commerce","version":"1.0","type":"link"}