Insert multiple Rows into Google Sheets

Nerd-Zone
1

Hi Everyone,

I do have some Scenarios where I would like to insert 50-100 rows into Google Sheets. Doing this every day takes up quite a lot of operations. I think I saw a video about a custom app to insert multiple rows into a Google Sheet with one operation. Did anyone of you see it or knows how to approach a solution for this?

Best,
Richard

2

Hey @Richard_Johannes ,

You can use the Google Sheet API to do a bulk insert. No custom app needed:

3 Likes
3

Awesome! Thank you very much Drivn! Haven’t got time to look at it but I am quite sure it relieves a lot of stress for me xD

4

@Richard_Johannes For bulk update, append and clear, we have built a tool where we can save tons of operations.

image
image728×376 43.5 KB

Feel free to book a slot from Calendly if interested for a demo:

2 Likes