How to add row to a google sheet?

[Tom Eastem]

Hi All,

I have two problems bothering me.

1. I would like to identify the first empty row in my google sheet

2. I would like to insert values into the first (identified before) empty row.

The values to insert:  barcode png and barcode request link.

I have generated my barcode with barcode API https://github.com/metafloor/bwip-js/wiki/Online-Barcode-API

I have tried to construct a query for Web component using POST without success using .

data.addRow();  // Add an empty row
data.addRow(['Hermione', new Date(1999,0,1)]); // Add a row with a string and a date value.

from https://developers.google.com/chart/interactive/docs/reference

There is an extension WebViewTools which can run a javascript frop AI2 app.
https://thunkableblocks.blogspot.com/2017/06/webviewtools-extension-for-app-inventor.html

Can anyone point me to a solution or provide a sample of code in javascript or blocks  to achieve this?

I will be very grateful for your help.

Thanks a bunch!

[TimAI2]

This is a google sheets / google apps script question :)

Have a look HERE or HERE

[TimAI2]

If you want to place an image in your google sheet, you will have to upload it first to Google drive, then add the link

HERE

Do this bit before the google sheet bit

[Tom Eastem]

Merveilleux!

Thank you very much.