Join us on July 16th as we explore real-world Reinforcement Learning Learn more

Exporting a dataset to Google Sheets

Level 1
Exporting a dataset to Google Sheets
Hi,

I'm trying to export data towards Google Sheets. I can retrieve data with the Google Sheets plugin, but now I want to send it.

How can I do this using the Google Sheets plugin?

With kind regards,

Tycho
0 Kudos
13 Replies
Dataiker
Dataiker
Hi,

You should first create a dataset with the plugin Google Sheets? Then, edit/create your recipe and select the dataset as the output.
Jeremy, Product Manager at Dataiku
0 Kudos
Level 1
Author
Great! Thanks for the explanation. But now I get this error:

Failed to write rows : : 'Worksheet' object has no attribute 'get_addr_int'

What does that mean?
0 Kudos
Level 1
Author
What module should I use to export the data to Google sheets?
0 Kudos
Level 1
Author
This is the error log:

2018-11-14 09:51:13,290 INFO Connecting to parent at port 53541
2018-11-14 09:51:13,291 INFO Connected to parent at port 53541
2018-11-14 09:51:13,397 INFO Processing task: write_rows
2018-11-14 09:51:14,195 INFO Refreshing access_token
Traceback (most recent call last):
File "/Applications/DataScienceStudio.app/Contents/Resources/kit/python/dataiku/connector/server.py", line 125, in serve
write_rows(connector, schema, partitioning, partition_id, input)
File "/Applications/DataScienceStudio.app/Contents/Resources/kit/python/dataiku/connector/server.py", line 63, in write_rows
writer.close()
File "/var/folders/k8/jbnml6rd43g6_3m16qrz1jxm0000gn/T/tmpgnqPYT/code.py", line 182, in close
self.flush()
File "/var/folders/k8/jbnml6rd43g6_3m16qrz1jxm0000gn/T/tmpgnqPYT/code.py", line 171, in flush
cell_list = ws.range( 'A1:%s' % ws.get_addr_int(num_lines, num_columns) )
AttributeError: 'Worksheet' object has no attribute 'get_addr_int'
0 Kudos
Dataiker
Dataiker
Did you install the python dependencies in the UI of Dataiku DSS?

I suspect that you don't have the versions of the dependencies expected by the plugin.
Jeremy, Product Manager at Dataiku
0 Kudos
Level 1
Author
What are the dependencies needed for this plugin?
0 Kudos
Dataiker
Dataiker
https://github.com/dataiku/dataiku-contrib/blob/master/googlesheets/requirements.json
Jeremy, Product Manager at Dataiku
0 Kudos
Level 1
Author
This plugin declares external dependencies HIDE
gspread (==0.4.0)
oauth2client (>=2.0.0,<2.3.0)
PyOpenSSL (>=0.15.0)
awesome-slugify (>=1.6.5)
To install them, run on the command line:
/DATA_DIR/dss_home/bin/pip install 'gspread==0.4.0' 'oauth2client>=2.0.0,<2.3.0' 'PyOpenSSL>=0.15.0' 'awesome-slugify>=1.6.5'
SUCCESSFULLY INSTALLED
0 Kudos
Level 1
Author
I'll try to reinstall the plugins.
0 Kudos
Dataiker
Dataiker
The plugin should work now.
Jeremy, Product Manager at Dataiku
0 Kudos
Level 1
Author
I'm still getting the same error. I already had all the dependencies installed. Is there anything else I can try to fix this?
0 Kudos
Dataiker
Dataiker
There might be a bug with the plugin. I will investigate. You can follow-up here: https://github.com/dataiku/dataiku-contrib/issues/91
Jeremy, Product Manager at Dataiku
0 Kudos
Level 1
Author
Are you getting the same error? Thank you! I'll follow the thread!
0 Kudos