How to add values ​​to columns without indexes?

Question

Google Sheets

How to work with Google Sheets API without range at all. I just need to add values ​​line by line to certain columns and so on.
Now, in order to add data, you need to write range where this data will be written (as far as I know)
. I just want to add data line by line, as, for example, in SQL.
More or less like this:

INSERT INTO (Колонка в на листе1, колонка на листе2) VALUES (Значение для колонки1, значение для колонки2)

As we can see, there is no need to specify any range here. Values ​​are added line by line only to the columns they need. Is there a way to implement similar via Google api, or maybe there is already some kind of wrapper?

Answer 1

No way, when it comes to the capabilities of the Google Sheet API.
No way, if we are talking about Google Apps Script.
Perhaps there is some kind of ORM that does this. But, by and large, this does not matter much, because. you end up having to call the method or endpoint with the parameter anyway range.
No indexes - no cartoons.
Examples for Google Apps Script
Tamotsu

function runTamotsuSample() {
  Tamotsu.initialize();
  const agent = Tamotsu.Table.define({
    sheetName: 'Sheet1',
    idColumn: 'id'
  });
  agent.create({
    date: new Date(),
    number: 100,
    string: 'Hi there'
  })
}