I am scraping lead data from Apify google maps scrawler and processing this data in Make.com.
Here is the screenshot of my previous workflow.
I wanted to add a feature to find the social media accounts of leads by scraping their websites. However, I couldn’t accomplish this in Google Sheets, so I switched to Airtable. Unfortunately, I ran into a problem: while I can create single records, every time I run the scenario, it processes thousands of records separately, which consumes a lot of operations.
Now, I want to know how I can upload all these leads to Airtable at once to minimize credit usage. In my previous workflow, I used a Text Aggregator to create strings of all the data and then bulk-uploaded them to Google Sheets using its API. Since I usually upload thousands of leads to Google Sheets, how can I achieve the same result in Airtable to ensure that all the leads are uploaded simultaneously, thereby reducing operational costs?
I need some help in building this, can anyone help me with this?