Company data by registration number — into таблица

The scenario takes a list of companies by registration number from таблица, pulls each one’s data from the registry and appends it, notifying mangoOffice.

  • A list of numbers from таблица
  • Data from the public registry
  • Name, status, address, line of business
  • A notification to mangoOffice when done
Google Sheets
Set it up for yourselfScriptera

How it works

To get mangoOffice notifications in Google Sheets, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Execute Workflow Manually
  2. Then: Settings
  3. Then: Get All CNPJs in Sheet
  4. Check: Loop CNPJs
  5. Then: Limit Notifier Interactions
  6. Then: Notify When Finish
  7. Then: Send API Request
  8. Then: Update CNPJ Info in Sheet

You can launch this mangoOffice + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios