How do I use package google-api-wrapper?

Ask the community
,
1

Starting more generally: What I’m trying to do is write to a Google Sheet from back-end Corvid code. If you can explain how to do that, in any way that works, you can ignore the rest of this question.

I shouldn’t have to deal with the details of authentication; it should be done by a package/module/ library on the Corvid end. (I know how to set up authentication on the Google end.) Which package?

Many packages claim to wrap Google Sheets API. But I found only three that are approved and installable. One provides only read access; no good. Another looks VERY old and unusable.

The third is google-spreadsheet. I was not able to make this work. I posted my specific question about that failure both here and on StackOverflow. Nobody was able to help.

So I went pawing through the other possibilities and found three or four others that might do it. I asked for approval for these, but only one was approved: google-api-wrapper. And I can’t figure out how even to start using this package.

https://github.com/svamja/google-api-wrapper/blob/master/README.md has the doc. Basic usage starts with

const Google = require('google-api-wrapper');

but ‘require’ is not defined in Corvid. (Puzzlingly, the editor does put the word in bold and blue, just like ‘import’, so something is weird.) Here are two other attempts that don’t work:

import 'google-api-wrapper';
import { Google } from 'google-api-wrapper;

Either one crashes my back-end code. (Something like the second option worked just fine with google-spreadsheet.)

So the question is: How do I get started with this package? What is the mapping from the information in the README above to usable Corvid code?

But as I said: a pointer to any way to write a Google Sheet from Corvid code, any way at all, would be greatly appreciated.

2

See Example: Google Sheets NPM .

3

Awesome. Wish I’d seen this a week ago. As I said, I hoped a library would do everything for me , especially authorization, but if I have to write it myself it’s nice to have something to copy.

One thing: Can you address the issue of the “require” statement? As I said, I can’t use this; the big red dot says “‘require’ is not defined” though it puts the word in bold. Even when I open the example you sent in the editor, and look at the code, I get this error (screenshot attached). What happened to ‘require’, and how do I get its functionality now?

1982×328 65 KB

4

@larry80875 Arrrrggghhh! Still not fixed? Not to worry - it’s flagged but it works.