Building Cost-Effective Automations with Make.com and Airtable

Introduction

• Automate repetitive tasks with Make.com
• Reduce monthly subscription costs by using fewer operations
• Process complex data with minimal operations

Understanding Operations in Make.com

• Each module used in Make.com costs one operation
• Looping through data increases operation costs significantly
• Example: Looping over 100 posts with two modules costs 200 operations

Efficient Data Processing Strategies

• Compare three strategies for processing data:
  1. Process in Make.com
  2. Process in Airtable using Airtable Automations and scripts

Method 1: Processing in Make.com

• API call to download posts
• Iterate over posts and perform data operations
• Insert data into Airtable
• High operation cost due to looping

Method 2: Processing in Airtable

• Insert data directly into Airtable as a task
• Airtable Automation processes data
  • Airtable is better for handling large data sets
• Only one Airtable automation run, regardless of operations

Benefits of Airtable

• Cost efficiency: Single automation run vs. multiple operations in Make
• Example: 100 posts with multiple operations in Make could cost 1000s, only one in Airtable

Handling Large JSON Data

• Direct text insertion might fail due to size limits
• Use Google Cloud Storage to save JSON data as a file
• Attach file to Airtable for processing

Alternative Method: JSON File Handling

• Upload data as JSON file to Google Cloud
• Attach file in Airtable for easier handling

Airtable Automation with Files

• Trigger based on successful API calls and non-empty fields
• Process data from JSON files

Advantages of Using Airtable for Data Processing

• Cost-effective: less expensive compared to Make.com per operation
• Flexibility: Handle complex operations in code

Limitations and Considerations

• Airtable script limited to 30 seconds
• Need to split tasks if data processing exceeds time limit
• Consider data size limits for text columns

Conclusion

• Airtable automations can significantly reduce costs
• Effective data management in automations
• Access further resources and community support through No Code Architects