I am a novice user who hasn’t been using Make.com for long. I’m creating automation scenarios with Make.com to improve work efficiency, but it’s not working well, so I’m posting a question. I hope my issue will be resolved through the helpful answers from kind people. I want to set it up so that when an Excel file is uploaded to Google Drive or MS OneDrive, a trigger runs to fetch that Excel file and process the contents in a specific sheet, then update Airtable. The reason I need to upload an Excel file is that the format provided by the client is Excel. I can download the file using the Google Watch File/Folders or OneDrive module, but the next steps aren’t working properly. Please help. Thank you.
Add a google drive watch Files module as the trigger to your scenario, Add a filter for Excel files(Check if the file name contains.xlsx, .xlsm, .xlsm or .CSV) or check for a specific folder, Add Google Drive Download a File, Add an Airtable Update a Record or Create a Record, Upload a test Excel file and run the scenario
Check if the data appears correctly in Airtable.