Daily payment reports loaded into your database, with an email summary

The scenario fetches the payment gateway report, unpacks and parses it, loads the transactions into your database and emails a confirmation.

  • The report is fetched automatically, every day, on schedule
  • Archives and spreadsheets are parsed without manual work
  • Transactions land in the database in one consistent format
  • A confirmation email shows the data arrived
Set it upScriptera

How it works

To connect SendGrid and Snowflake, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Schedule Trigger
  2. Then: TELR API
  3. Then: Convert XML to JSON
  4. Then: Logic for date
  5. Then: Edit Fields
  6. Then: TELR API WITH DATE
  7. Then: Compression
  8. Then: Extract from File
  9. Then: Data Formation
  10. Then: Code in JavaScript3
  11. Then: Data Insert SQL
  12. Check: Success Condition
  13. If yes: Send email

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

Similar scenarios