Is it possible to do bulk write by Looping through each table row?

hey everyone! I am trying to load over a hundred documents to firebase through a Google Sheet. Right now I am writing to firebase row by row (by using the action button on each row of a table). I am wondering how I can click a single button to loop through each row in my table and write to firebase.

See below for what I'm doing right now:
Insert document into firebase from a Google Sheets table:

{
"name":{{table1.selectedRow.data.name}},
"description":{{table1.selectedRow.data.description}},
"affirmation":{{table1.selectedRow.data.affirmation}},
"minutes":{{Number(table1.selectedRow.data.minutes)}},
"order":{{Number(table1.selectedRow.data.order)}},
"video-url":{{table1.selectedRow.data['video-url']}},
"image-url":{{table1.selectedRow.data['image-url']}},
"media-ref":{{table1.selectedRow.data['media-ref']}},
"props-needed":{{table1.selectedRow.data['props-needed']}},
"overlay-hex":"242524",
"overlay-alpha":0.50,
"premium":{{(table1.selectedRow.data.premium=='TRUE')}},
"type":"class"
}

Hey there @sunny! This is definitely doable. We have a tutorial in our docs that walks through how to do this with a CSV -- it should be able to get you to the finish line.
https://docs.retool.com/docs/scripting-retool#section-example-firing-an-api-request-for-each-row-in-a-csv