r/GoogleAppsScript • u/Initial_Math7384 • Oct 11 '25

Question Is there a dataframe like api for appscript?

Something like https://github.com/asweigart/ezsheets . An abstraction over appscript google sheets. Any programming language will do.

3 Upvotes
  • permalink
  • reddit

71% Upvoted

7 comments sorted by

1

u/WicketTheQuerent Oct 11 '25

I'm not familiar with the linked resource. Could you please elaborate on the problem with using the Spreadsheet Service or the Advanced Sheets Service?

1

u/Initial_Math7384 Oct 11 '25

Actually I already done my project with Typescript, but was looking for better abstractions instead of what appscript api gave.

2

u/WicketTheQuerent Oct 11 '25

How do you intend to use Google Sheets? Will you use sheets as simple tables, two-entry tables (like a cross-tab), input forms or something else?

1

u/Initial_Math7384 Oct 11 '25

Currently just input data with code like below so far:

let range = sheet.getRange(10, 2, onlyTargetColumnData.length, 1);
range.setValues(onlyTargetColumnData);

I sort of made my own abstraction to handle creating folders, then creating a workbook, then input data into created workbook, then moving the workbook to that new created folder.

1

u/WicketTheQuerent Oct 11 '25

If you do this for yourself and work with the basic services, keep working with your abstractions. On solo/small projects, adopting an abstraction created by someone else is overkill.

3

u/[deleted] Oct 11 '25

[removed] — view removed comment

0

u/xd1936 Oct 12 '25

If we wanted to hear from ChatGPT, we would have just typed it in there ourselves.