Hello everyone,
I’m a junior data analyst and recently I was asked at work to integrate new data that is external to our management system. This data consists of Excel spreadsheets stored in Airtable. While researching, I noticed that there are several ways to integrate this data.
For example, one could use “bridge” solutions like OneDrive or SharePoint, or connect directly to Airtable via its API.
I was able to connect directly using the API (after creating a Personal Access Token), performing a blank query and using an M script to retrieve over 20,000 records. However, I would like to hear from more experienced people whether this could be the best approach compared to using a bridge solution. I personally think it is, but I would appreciate the opinion of experts.
I have tested this with free accounts and demo Excel files with over 20,000 records, and I can retrieve them both directly via API and using OneDrive or SharePoint.
Additionally, I understand that the client has a paid Airtable plan, so there shouldn’t be any limits, right? For example, the client should be able to upload as many Excel files as they want to Airtable.
I would greatly appreciate any advice or guidance from more experienced professionals.
