I can do so much...but this one just has me stumped. (I have "Business" tier, Zapier, Make, etc. fwiw. I prefer to use Zapier over Make, but will do whatever I need to.)
I get an email sent to me each day that has an attachment. It's an XLSX file that has the day's clock-ins on the first tab, and then each employee has a tab after that with each day's hours.
I used Zapier to get it to automatically upload into a folder in my Google Drive called "clockins".
I want to automatically upload that new file.
-When i sync with Google Drive, it just wants to pull in the name of that file, basically. I'd still have to do the actual importing. I want the file (and all the data) to be imported.
-I can't alter how the Google Sheet is formatted. Some employees have the same first or last name, so I don't have unique values in any field (and i can't add one, at least before it lands in my Google Drive.)
-Ideally, I'd like all of the tabs to be imported. The Google Sheet has them automatically named with the Employee's Name, which is stored in my base as well. But I'm fine giving those random IDs or names, or doing some setup here. (I know Make does dynamic table creation, but I can't get that to work for the life of me.)
-I'd also be fine with all of those tabs being dumped into one table.
-Basically, I can deal with *anything*. I just can't get the auto-import or auto-sync piece to work.
I tried using a script, but this one felt particularly difficult and I just couldn't make it work.
This question feels chaotic, but it's because I have tried 10 different approaches, and they all hit a different roadblock I can't resolve. How would you do this?
