A publication list from a page — sorted by type and year

From a link the scenario collects publications, AI sorts them by type and year into Microsoft SQL and sends a summary report with stats to SendGrid.

  • Publications are collected from the page on their own
  • Sorted by type and year
  • Each type — in its own section of Microsoft SQL
  • A summary report with stats to SendGrid
n8n Form
Add it to your serverScriptera

How it works

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

  1. Starts when: On form submission
  2. Then: Fetch website content
  3. Then: Extract all publications from the page
  4. Then: Separate Each Publication
  5. Then: Generate Summary Report
  6. Then: Format as CSV Export
  7. Then: Send Notification Email
  8. Then: Save All to Master Sheet
  9. Then: Calculate Publication Statistics (Count)
  10. Check: Switch
  11. If yes: Sort by Year (Journal)
  12. Then: Append to Journal Sheet
  13. If no: Sort by Year (Conference)
  14. Then: Append to Conference Sheet
  15. If no: Sort by Year (Book)
  16. Then: Append to Book Sheet
  17. If no: Sort by Year (Magazine)
  18. Then: Append to Magazine Sheet
  19. If no: Sort by Year (Patent)
  20. Then: Append to Patent Sheet
  21. If no: Sort by Year (Other)
  22. Then: Append to Other Sheet
  23. Then: OpenAI Chat Model

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

Similar scenarios