Hello Make.com Community,
I’m working on a scenario where I need to automate the process of receiving attachments from Airtable, analyzing them, and then saving the results into Notion. I’ve created a blueprint, but I’m running into some issues and would love some help to get it working smoothly.
Scenario Outline:
- Receive Attachments from Airtable: I need to pull attachments from Airtable, which can be in Excel or CSV format.
- File Type Check: The scenario should then identify if the attachment is an Excel or CSV file.
- File Analysis with ChatGPT: Once the file type is confirmed, it should be moved to a specific path for analysis. Here, I’m using a ChatGPT prompt to analyze the file and generate statistics, tables, and figures.
- Save Results in Notion: The final step is to take the analysis results from ChatGPT and save them into Notion as a report, including all statistics, tables, and figures.
Challenges I’m Facing:
- I’m having trouble setting up the file type check and ensuring only Excel or CSV files are moved for analysis.
- I’m not sure how to structure the prompt for ChatGPT within Make.com to handle file analysis efficiently.
- I’m encountering issues with formatting the output from ChatGPT and integrating it into Notion, particularly when it comes to creating tables and figures.
blueprint-2.json (60.6 KB)
Request for Assistance:
- What’s the best way to structure the ChatGPT prompt for analyzing Excel/CSV data within this workflow? because when I ran the scenario, ChatGPT could not identify the CSV.
- Have any tips on formatting the output for Notion, especially regarding tables and figures?
Any help or pointers would be greatly appreciated!
Regards,
Ahmad