Question

Problem exporting multiple records (Creating multiple rows at once)

  • 22 November 2020
  • 3 replies
  • 34 views

I have a program that scraps a few hundred Instagram posts (Likes, comments, caption, publish date, etc) and I need this data exported into a database.

 

I first tried google sheets, which worked fine at first but quickly reached API limitations (I quickly learned google sheets is not made to store large databses)

 

Next, I tried airtable, but the problem is zapier does not have the option to create multiple records on airtable. Instead, it combines everything into a single record.

 

So, google sheets has the ability to add multiple rows at once, but can’t handle large databases;
Airtable does not have the ability to add multiple rows at once, but can handle large database.

Simply put, I need to find a software that does both

 

 I’ve looked for hours with no luck. Is anyone able to give me some suggestions?


3 replies

Userlevel 7
Badge +6

Hello! It sounds like you might need to consider your toolset, if you've outgrown Airtable, and you're using this for an app something like Firebase could suit your needs - alternatively MongoDb

https://zapier.com/apps/firebase/integrations

https://zapier.com/apps/mongodb/integrations

Once you begin to outgrow something like an Airtable or Google Sheets, you are getting into more technical territory, so I would honestly recommend consulting with a developer who can point you in the right direction here. 

Hello! It sounds like you might need to consider your toolset, if you've outgrown Airtable, and you're using this for an app something like Firebase could suit your needs - alternatively MongoDb

https://zapier.com/apps/firebase/integrations

https://zapier.com/apps/mongodb/integrations

Once you begin to outgrow something like an Airtable or Google Sheets, you are getting into more technical territory, so I would honestly recommend consulting with a developer who can point you in the right direction here. 

Thank you, any tips on where to find a developer able to help?

Userlevel 7
Badge +9

Hi @mindbiz!

A great place to start is the Zapier Experts directory, where you can find a variety of certified Zapier experts :) To help you find the right person, you can filter the listings by:

  • Expert Type
  • Location
  • Project Budget
  • Services Offered
  • Software Specializations

Hope that helps!

 

Reply