Datafiles
Discover how automations can efficiently capture and store information in datafiles for seamless integration with other tools. Our document outlines the initial functionality, such as generating daily CSV files with the option to append data. You can conv
Automations can capture information into datafiles for the purpose of loading that information into other tools.
The initial datafile functionality was built with the goal of loading data from automations into AI tools like ChatGPT.
To that end, the initial functionality supports generating daily CSV files. Automations just need to use the "append to daily CSV datafile" action to write information into a CSV datafile:
The action can be configured with the CSV columns, a topic, and a maximum file size:
The topic is used to help organize datafiles across multiple automations.
If the maximum file size limit is reached for the current day, additional information is written into separate datafiles having "_X" appended to their names, where X is an increasing number.
The action takes care of automatically writing the column names into a header row.
The CSV file names contain the current date as determined from the timezone setting in the account.
Datafiles are automatically purged from the system based on a configuration setting. Currently the setting is 30 days.
When an account has datafiles present, a menu option appears under the automation editor's account menu:
Select a topic on the left to access its datafiles. Select and click the button to download a datafile, or double-click the datafile to download. Datafiles are downloaded as ZIP files.
