New to OpenFn: tried using language-googlesheets through selecting Google Sheets for adapter in dashboard

38 views
Skip to first unread message

charan...@gmail.com

unread,
Apr 19, 2017, 4:38:30 PM4/19/17
to OpenFn Community
I get the following. Do I need to request specifically, which language packs I would like enabled?

{ Error: Cannot find module '/home/production/repo/./priv/language_packs/language-googlesheets'
    at Function.Module._resolveFilename (module.js:455:15)
    at Function.Module._load (module.js:403:25)
    at Module.require (module.js:483:17)
    at require (internal/module.js:20:19)
    at getModule (/home/production/repo/node_modules/diesl/lib/utils.js:26:14)
    at Object.<anonymous> (/home/production/repo/node_modules/diesl/lib/cli.js:139:23)
    at Module._compile (module.js:556:32)
    at Object.Module._extensions..js (module.js:565:10)
    at Module.load (module.js:473:32)
    at tryModuleLoad (module.js:432:12) code: 'MODULE_NOT_FOUND' }


downs....@gmail.com

unread,
Apr 19, 2017, 5:06:15 PM4/19/17
to OpenFn Community, charan...@gmail.com
Hi there! Right now Google Sheets is supported via scripts publishing. OpenFn.org clients use Sheets as a source, rather than a destination. (A common use case is pushing new submissions from a Google Form to OpenFn, which then loads them into DHIS2 or Salesforce.)

It looks like the Google Sheets adaptor—for using Sheets as a destination—has been specified in the adaptors list, though it's not yet been officially released to the hosted service. That's a bug and I'll push a fix (removing it from that list until it's official) tomorrow!

Are you trying to use Google Sheets as a source or a destination? You can expect the destination adaptor to be live in the next week or so.

Taylor

Taylor Downs

unread,
Apr 20, 2017, 7:04:57 AM4/20/17
to OpenFn Community, charan...@gmail.com, downs....@gmail.com
Update: The Google Sheets adaptor no longer appears in OpenFn.org as an option when creating a new job. You can use it with our open-source tools or wait for its official release sometime next week.

Taylor

ha...@livelyminds.org

unread,
Oct 2, 2018, 11:21:22 AM10/2/18
to OpenFn Community
Is there any guidence that can accompany this? I am having issues with pushing my OpenFN data to Google Sheets. 

downs....@gmail.com

unread,
Oct 3, 2018, 4:51:30 AM10/3/18
to OpenFn Community
Hi Harry. The Sheets adaptor is live, and I've picked up your question on the other thread! Let's continue it over there.
Reply all
Reply to author
Forward
0 new messages