All Apps and Add-ons

Google Import/Export app: Problems importing a spreadsheet

New Member


Please, someone can guide me with an error that I am getting when importing a spreadsheet.

Perform the installation according to what is indicated here (

1) Create a lookup file
Create a lookup file. You can use the Lookup Editor app to do this if you want.

2) Write the search to populate the lookup
Create your search to populate the lookup with the data that you want it to contain. You can use the "outputlookup" search command to do this. You will probably want to use the "append" argument.

3) Create the input
Create the Google Import/Export input. Select the lookup file you created and make sure that you make the operation "export".

Then, I shared a spreadsheet with the service user (You can edit), I have installed the version of the app v1.0.2. When throwing the query:

index = _internal (service_account_keys AND sourcetype = splunk_web_service) OR (sourcetype = google_spreadsheet_modular_input)

I get the following error:

2018-06-19 11:36:39,234 ERROR A general exception was thrown when executing the export
Traceback (most recent call last):
File "/opt/splunk/etc/apps/google_drive/bin/", line 142, in export_file
google_lookup_sync = GoogleLookupSync(client_email, private_key, logger=self.logger)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/", line 62, in init
self.gspread_client = self.make_client(private_key, client_email)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/", line 87, in make_client
return gspread.authorize(credentials)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/", line 326, in authorize
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/", line 85, in login
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/", line 633, in refresh
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/", line 842, in _refresh
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/", line 869, in _do_refresh_request
body = self._generate_refresh_request_body()
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/", line 1549, in _generate_refresh_request_body
assertion = self._generate_assertion()
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/", line 1677, in _generate_assertion
private_key, self.private_key_password), payload)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/", line 92, in make_signed_jwt
signature = signer.sign(signing_input)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/oauth2client/", line 99, in sign
return crypto.sign(self._key, message, 'sha256')
AttributeError: 'module' object has no attribute 'sign'


Tags (1)
0 Karma
Get Updates on the Splunk Community!

Infographic provides the TL;DR for the 2023 Splunk Career Impact Report

We’ve been shouting it from the rooftops! The findings from the 2023 Splunk Career Impact Report showing that ...

Splunk Lantern | Getting Started with Edge Processor, Machine Learning Toolkit ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...