HTTPError when exporting to Google sheet

[laga2k]

I have successfully used the Google Import/Export app to import lookups from Google Drive, but when trying to export a lookup table to a sheet, only the first (header) row actually appears in the sheet. I tried to investigate and found this error in google_spreadsheet_modular_input.log, which may or may not be related:

   2019-02-19 20:21:18,258 ERROR A general exception was thrown when executing the export
    Traceback (most recent call last):
      File "/opt/splunk/etc/apps/google_drive/bin/google_spreadsheet.py", line 143, in export_file
        last_updated = google_lookup_sync.export_lookup_file(lookup_name, None, None, spreadsheet_title, worksheet_name, session_key)
      File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 197, in export_lookup_file
        return self.export_lookup_file_full_path(destination_full_path, namespace, owner, google_spread_sheet_name, worksheet_name, session_key, lookup_name=lookup_name)
      File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 264, in export_lookup_file_full_path
        google_work_sheet.update_cell(row_number, col_number, value)
      File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/models.py", line 445, in update_cell
        self.client.put_feed(uri, ElementTree.tostring(feed))
      File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/client.py", line 277, in put_feed
        raise ex
    HTTPError

Is there something I need to do to get a lookup to export correctly? I am certain that the app has write access to the sheet in question. Thank you!

[LukeMurphey]

Is there any more details about the HTTPError (like the HTTP code)?

[laga2k]

No, there is no HTTP code specified, and that seems to be the extent of the error message.

[ertipton]

I am seeing the exact same issue. Only header row is updated similar errors:

2019-05-23 23:43:11,489 ERROR A general exception was thrown when executing the export
Traceback (most recent call last):
  File "/opt/splunk/etc/apps/google_drive/bin/google_spreadsheet.py", line 143, in export_file
    last_updated = google_lookup_sync.export_lookup_file(lookup_name, None, None, spreadsheet_title, worksheet_name, session_key)
  File "/data/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 197, in export_lookup_file
    return self.export_lookup_file_full_path(destination_full_path, namespace, owner, google_spread_sheet_name, worksheet_name, session_key, lookup_name=lookup_name)
  File "/data/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 264, in export_lookup_file_full_path
    google_work_sheet.update_cell(row_number, col_number, value)
  File "/data/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/models.py", line 445, in update_cell
    self.client.put_feed(uri, ElementTree.tostring(feed))
  File "/data/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/client.py", line 277, in put_feed
    raise ex
HTTPError