{"product_id":"n8n-workflow-employee-numbers-id-cards-with-google-sheets-gmail","title":"n8n Workflow: Employee Numbers \u0026 ID Cards with Google Sheets + Gmail","description":"\u003ch3\u003eGenerate employee ID cards (PDF + optional printing) from Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow is triggered with an \u003cstrong\u003eemployee_id\u003c\/strong\u003e, looks up the employee in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, ensures a unique \u003cstrong\u003eemployee number\u003c\/strong\u003e, requests missing photos via \u003cstrong\u003eGmail\u003c\/strong\u003e, then renders a signed\/verified \u003cstrong\u003eID card PDF\u003c\/strong\u003e through an HTTP renderer service and optionally sends it to print (or logs a GA print task).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives an employee_id\u003c\/strong\u003e and finds the matching row in the Google Sheets \u003cem\u003eEmployees\u003c\/em\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnsures a unique employee number\u003c\/strong\u003e: if the employee number is missing, it generates one, checks for collisions in Google Sheets, and updates the employee row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles missing photos\u003c\/strong\u003e: if the employee photo URL is missing, it appends an \u003cstrong\u003eID Cards\u003c\/strong\u003e record with \u003cem\u003ewaiting_photo\u003c\/em\u003e, creates a photo-request task in the \u003cem\u003eTasks\u003c\/em\u003e sheet, and sends a request email via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates or updates ID card data\u003c\/strong\u003e: if a photo is available, it finds an existing ID card row in \u003cem\u003eID Cards\u003c\/em\u003e, generates or reuses a card ID and verification token, and updates the record.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRenders a PDF\u003c\/strong\u003e: sends an \u003cstrong\u003eHTTP request\u003c\/strong\u003e to an ID card renderer service using employee data and a verification URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePost-render actions\u003c\/strong\u003e: on success, updates the card with \u003cem\u003edigital_file_url\u003c\/em\u003e, reads \u003cem\u003eprint_mode\u003c\/em\u003e from the \u003cem\u003eConfig\u003c\/em\u003e sheet, and either:\n    \u003cul\u003e\n      \u003cli\u003esends a print job via HTTP,\u003c\/li\u003e\n      \u003cli\u003ecreates a GA print task in Google Sheets, or\u003c\/li\u003e\n      \u003cli\u003emarks the card as digitally activated.\u003c\/li\u003e\n    \u003c\/ul\u003e\n    Finally, it appends an \u003cem\u003eid_card_generated\u003c\/em\u003e event.\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling\u003c\/strong\u003e: if rendering fails, it marks the ID card as failed and appends an \u003cem\u003eid_card_render_failed\u003c\/em\u003e event.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOnboarding automation: generate employee numbers and trigger ID card creation as soon as a new hire appears in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eMissing asset workflow: automatically request missing employee photos and queue follow-up tasks via Gmail and the Tasks sheet.\u003c\/li\u003e\n  \u003cli\u003eSecure card generation: produce verified ID card PDFs and coordinate printing using Config-driven print_mode.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/actions\u003c\/strong\u003e: if, set, no op, merge, gmail, and crypto (for verification\/card token logic).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration: \u003cem\u003eEmployees\u003c\/em\u003e, \u003cem\u003eID Cards\u003c\/em\u003e, \u003cem\u003eTasks\u003c\/em\u003e, and \u003cem\u003eConfig\u003c\/em\u003e sheets for state tracking and print mode.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP requests\u003c\/strong\u003e: call the ID card renderer service and (optionally) send print jobs.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824223346867,"sku":"N8N-18134","price":77.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/r40bGGMfCz4htORMAS-b4_vrgUUiSo.png?v=1786613131","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-employee-numbers-id-cards-with-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}