# How to Speed Up Creating Rows in a Google Sheet

**URL:** <https://community.thunkable.com/t/how-to-speed-up-creating-rows-in-a-google-sheet/1637790>\
**Category:** Questions about Thunkable X\
**Tags:** google-sheets\
**Created:** [November 29, 2021, 1:07am UTC](https://community.thunkable.com/t/how-to-speed-up-creating-rows-in-a-google-sheet/1637790 "2021-11-29T01:07:43Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [November 29, 2021, 1:07am UTC](https://community.thunkable.com/t/how-to-speed-up-creating-rows-in-a-google-sheet/1637790/1 "2021-11-29T01:07:43Z")

</div>

I’m storing data in Firebase for a book catalog app I’m developing. I’d like the user to be able to upload the entire Firebase database to a Google Sheet. I have it working but the transfer of data is quite slow. It currently takes 6 seconds to create 8 rows of 16 columns each (one book’s data in each row). That seems really slow to me. I’ll eventually be cataloging hundreds of books so that transfer could take several minutes.

Any suggestions for speeding things up? I already assigned the cloud data to an app variable to prevent having to access Firebase over and over (for each column value).

I’m also open to other suggestions such as transferring data to Airtable instead of Google Sheets or using an API/script to create the rows in the Google Sheet (perhaps that would be faster?).

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/b/6bce350c7e44d900581c935483104da2d00afa23.png)

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/3/73334bbcad47e5a7b599d1dc72dd56cd5151b49c.png)

---

_[View the full topic](https://community.thunkable.com/t/how-to-speed-up-creating-rows-in-a-google-sheet/1637790)._
