Problem publishing from ODK Aggregate to Google Spreadsheets

Hello!

What is the problem? Please be detailed.
I have created a form at ODK Aggregate instance but trying tu publish it to Google Spreadsheet gives some strange windows back instead of "Grant Access" page.

Clicking Publish:

What is this about? I have some doubts about applying the right role to the service account. Documentation just says select a role, but does not specify which one.

OK, after entering my gmail address I get a confirmation window:

I click OK and in a few seconds there is an error displayed:
2018-06-27%2000_38_26-ODK%20Aggregate

I feel like I'm missing something obvious.

What ODK tool and version are you using? And on what device and operating system version?

  • ODK Aggregate v1.6.0-beta.0

    • Installed using ODK-Aggregate-v1.6.0-beta.0-Windows.exe
    • Installed it to Google App Engine
    • Followed this instructions for installation
    • Followed this instructions to set up OAuth access to Google APIs
  • ODK Collect v1.15.1

    • No issue related to publishing here: I have successfully got a form from ODK Aggregate, filled it and sent it.

What steps can we take to reproduce the problem?
Not sure, I've just followed the instructions.

Tried roles for the service account: Project -> Editor and Datastore -> cloud Database User.

What you have you tried to fix the problem?
Different roles for the service account, reinstalling ODK Aggregate, different google accounts, tried everything on freshly created google account.

Anything else we should know or have? If you have a test form or screenshots or logs, attach here.

I can provide access to ODK Aggregate instance, App Engine and tmp google account where this behaviour is reproduced.

Thank you in advance.

2 posts were merged into an existing topic: ODK Aggregate v1.6.0 Beta