A data report with analysis and charts to your inbox

The scenario brings together data from Microsoft SQL, Google Sheets or a file, analyzes it, builds charts and emails a ready report to Mautic.

  • Data from a database, sheet or file — together
  • Analysis, interpretation and charts — automatic
  • A ready report arrives to Mautic
  • No crunching numbers by hand

How it works

To move data from Microsoft SQL to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Start
  2. Then: Sample Data
  3. Then: Process Data
  4. Then: DataVisualization
  5. Then: Process Visualization Data
  6. Then: Convert to HTML File
  7. Then: Send DataVisualization
  8. Then: DataAnalysis
  9. Then: Convert markdown to HTML
  10. Then: Send DataAnalysis message
  11. Then: DataInterpretation
  12. Then: Convert markdown to HTML 2
  13. Then: Send DataInterpretation message
  14. Then: Get data from database
  15. Then: Get data from Google Sheets
  16. Then: Get data from local file
  17. Then: Extract JSON from xlsx file

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