{"product_id":"borme-spain-company-data-to-google-sheets-via-apify-gmail","title":"BORME Spain Company Data to Google Sheets via Apify \u0026 Gmail","description":"\u003ch3\u003eGet Spain’s newest corporate incorporations into Google Sheets automatically—then email a daily summary\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads Spain’s official \u003cstrong\u003eBORME\u003c\/strong\u003e gazette via \u003cstrong\u003eApify\u003c\/strong\u003e and, every weekday at 09:00, appends each newly incorporated company to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—with a \u003cstrong\u003eGmail\u003c\/strong\u003e email summary for quick review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes at \u003cstrong\u003e09:00, Monday to Friday\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches the latest business day data:\u003c\/strong\u003e sends your selected \u003cstrong\u003eprovinces\u003c\/strong\u003e and \u003cstrong\u003eact types\u003c\/strong\u003e to the \u003cstrong\u003eApify BORME Corporate Acts Scraper\u003c\/strong\u003e actor and retrieves the most recent dataset.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates one structured row per company:\u003c\/strong\u003e extracts company details from the notice text, including \u003cem\u003ecompany name, province, registry number, start of operations, corporate purpose, address, share capital, and a link to the official BORME PDF\u003c\/em\u003e. (People mentioned in the notice are not copied.)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets:\u003c\/strong\u003e adds the rows to the spreadsheet and the sheet you select.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail summary:\u003c\/strong\u003e builds an HTML email including counts per province plus a preview list of companies, then emails it via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack \u003cstrong\u003eSpain company formation (BORME)\u003c\/strong\u003e changes by province for compliance or market monitoring.\u003c\/li\u003e\n  \u003cli\u003eFeed an internal CRM or research process with fresh corporate entities in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eOperations teams who need \u003cstrong\u003edaily incorporation visibility\u003c\/strong\u003e without manual BORME lookups.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes: \u003cstrong\u003eApify\u003c\/strong\u003e (via \u003ccode\u003e@apify\/n8n-nodes-apify\u003c\/code\u003e), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, plus supporting nodes like \u003cstrong\u003eCode\u003c\/strong\u003e\/\u003cstrong\u003eSet\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eApify credential: add your \u003cstrong\u003eApify API token\u003c\/strong\u003e to n8n (and use the verified community node on self-hosted n8n).\u003c\/li\u003e\n  \u003cli\u003eGoogle Sheets header row must be exactly:\u003cbr\u003e\n    \u003ccode\u003edate, province, companyName, registryNumber, actType, startOfOperations, corporatePurpose, address, capital, otherActs, bormeId, sourceUrl\u003c\/code\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132839973043,"sku":"N8N-20169","price":61.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/YGFLjOXNWFUjT_flicIGy_IvBaV1nY.png?v=1790759580","url":"https:\/\/buyflowscripts.com\/products\/borme-spain-company-data-to-google-sheets-via-apify-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}