Converting scraped JSON to CSV and emailing it automatically

Triggers & Integrations
1

I have a daily cron job that scrapes a directory. Right now, it saves as JSON. My boss wants a CSV report emailed to him every morning at 8 AM.

Can RTILA handle the format conversion and the email delivery in one go?

2

Absolutely. This is a perfect use case for chaining triggers.

  1. Trigger 1 (File Formats): Add the convert_format trigger. Set the input format to json (you can pass your {dataset} directly into the input_data field) and the output format to csv.
  2. Trigger 2 (Email): Add the send_email trigger. Configure your SMTP settings. In the attachment_path field, use the dynamic output variable from Trigger 1 (it will look something like {trigger_1.converted_file_path}).

When your scheduled project finishes, the Python Relay will instantly convert the data in-memory using pandas, save the CSV, attach it to an email, and send it off to your boss. You can set it and forget it.