Integrations · Google Sheets
Google Sheets: Company status, hiring, public tenders and remote jobs as spreadsheet functions.
Install from the script files today; Google Workspace Marketplace listing in preparation.
What it covers
- =ARCADIUM_VERIFY(domain) or (id, country): live register and EU VAT status
- =ARCADIUM_HIRING(domain): ATS, open jobs, jobs posted in 30 days, 30-day change
- =ARCADIUM_TENDERS(country, cpv): public tenders and awards by buyer country and CPV code
- =ARCADIUM_REMOTE_JOBS(q): open remote jobs direct from employers
- Range formulas fetch in parallel batches of 20; answers are cached 6 hours so recalculating costs no calls
Install
- Create a free API key on the sign-up page.
- In a Sheet open Extensions > Apps Script and paste Code.gs and appsscript.json from the integration files.
- Reload the sheet, then Extensions > Arcadium Data > Set API key and paste the key. It is stored in your own user properties, not in the sheet.
- Type =ARCADIUM_HIRING(A2:A100) next to a column of domains.
Errors share one shape, { "error": "<code>", "message": "..." }: 404 not_found means no data for that company (do not retry), 429 means wait Retry-After seconds, 401 means the key is missing or wrong.