Automation to Read New spread sheet created in drive

You can do this with Make. Sorry, I can’t talk you through the entire process because it would take an hour or so to setup, but if you’re brand new to Make, I created this basic navigation video for Make, along with providing the link to Make’s free training courses. There are also many Make experts hanging out there who may be able to answer other Make questions. 

Thank you for the reply @ScottWorld 

I just tried by signing up. I had a basic question, It says trigger is when I create a row, Does it even have an option for trigger when I create a new spreadsheet?

Regards,

Dilip

Yes, you would need to start with a Google Drive module to watch for new files.

You may also want to just export the final spreadsheet as a CSV file into a specific watch folder in Google Drive, and then use Make’s CSV modules to automatically parse the CSV file into Airtable. That would be an easier setup in Make.

Thank you for the revert @ScottWorld  I however got it to work using Google App scripts as I could tweak my workflow. however I did give  Make a try and seems to be promising. Thank you again.