{"product_id":"legiscan-google-sheets-n8n-workflow-for-bill-digests","title":"LegiScan + Google Sheets n8n Workflow for Bill Digests","description":"\u003ch3\u003eTurn Legislation Monitoring into Actionable Bill Digests (Auto-Generated)\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eLegiScan + Google Sheets n8n Workflow for Bill Digests\u003c\/strong\u003e automatically scans U.S. bills for new and updated activity, logs results in Google Sheets, and drafts email digests for human review—so you can stay on top of legislation without manual searching.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 7:00 AM\u003c\/strong\u003e and checks whether \u003cem\u003eLEGISLATION_SEARCH_TERMS\u003c\/em\u003e is configured.\u003c\/li\u003e\n  \u003cli\u003eIf search terms exist, it builds \u003cstrong\u003eone LegiScan query per practice-area term\u003c\/strong\u003e and calls the \u003cstrong\u003eLegiScan getSearch API\u003c\/strong\u003e to retrieve matching bill results.\u003c\/li\u003e\n  \u003cli\u003eIt reads your \u003cstrong\u003e“Bill Tracker” Google Sheet\u003c\/strong\u003e, compares new results against previously tracked bills, and \u003cstrong\u003eappends or updates tracker rows\u003c\/strong\u003e for bills that are new or have status changes.\u003c\/li\u003e\n  \u003cli\u003eIt filters to \u003cstrong\u003ealert-worthy bills\u003c\/strong\u003e and creates a \u003cstrong\u003esingle digest\u003c\/strong\u003e grouped by practice area, including a keyword-based \u003cstrong\u003e“why it matters”\u003c\/strong\u003e blurb based on each bill’s last action.\u003c\/li\u003e\n  \u003cli\u003eIf search terms are missing, it drafts a \u003cstrong\u003esetup-needed notice\u003c\/strong\u003e instead of performing searches.\u003c\/li\u003e\n  \u003cli\u003eThe workflow generates a \u003cstrong\u003eunique digest ID\u003c\/strong\u003e, appends the draft to \u003cstrong\u003e“Legislation Digest Drafts”\u003c\/strong\u003e, and sends an \u003cstrong\u003eHTML review-request email\u003c\/strong\u003e via \u003cstrong\u003eSMTP\u003c\/strong\u003e to the reviewer.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly on Monday at 8:00 AM\u003c\/strong\u003e: it summarizes all tracked bills by practice area and emails a \u003cstrong\u003elandscape summary\u003c\/strong\u003e via SMTP.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLegal ops or policy teams tracking \u003cstrong\u003epractice-area specific bill activity\u003c\/strong\u003e daily and weekly.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want a \u003cstrong\u003erepeatable, reviewable\u003c\/strong\u003e legislative update process.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building reliable \u003cstrong\u003eLegiScan + Google Sheets\u003c\/strong\u003e monitoring pipelines in n8n.\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 LegiScan API, Google Sheets, SMTP email\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools:\u003c\/strong\u003e if, code, http request, google sheets, email send, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired inputs:\u003c\/strong\u003e \u003cem\u003eLEGISCAN_API_KEY\u003c\/em\u003e, \u003cem\u003eLEGISLATION_SEARCH_TERMS\u003c\/em\u003e, and \u003cem\u003eFIRM_FROM_EMAIL\u003c\/em\u003e (SMTP setup)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001848582323,"sku":"N8N-19471","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/tsEmeUm2_ou4JM-_ILZpw_juOCUu4t.png?v=1789117583","url":"https:\/\/buyflowscripts.com\/products\/legiscan-google-sheets-n8n-workflow-for-bill-digests","provider":"N8N Commerce","version":"1.0","type":"link"}