Question

Problem exporting multiple records (Creating multiple rows at once)

  • 22 November 2020
  • 3 replies
  • 97 views

Userlevel 1

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?


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 1

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 +11

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!

 

Userlevel 7
Badge +9

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.