<aside> šŸ“Š

Automated Xero Data Export and Attachment: This automation uses a workflow in Make to streamline financial data extraction and task updates in Asana.

When a task is marked as completed in Asana, the workflow:

  1. Retrieves financial data from Xero via API.
  2. Processes and stores the data in Google Sheets for organization.
  3. Formats the data into a CSV file using built-in tools.
  4. Uploads the file back to the Asana task as an attachment.
  5. Clears the temporary data in Google Sheets for the next run.

The workflow ensures a consistent and automated process for exporting, formatting, and attaching financial data to tasks, eliminating the need for manual handling.

</aside>

Make P1 - Automated Export Account Transactions from Xero - Upload CSV to Asana (1).png