Sign in to join the conversation:
Hi, i have enabled Google forms sync for Smartsheets, when I click the add-on for smart sheets in a form and it tries to connect to SS, I get this error:
Smartsheet Sync:
Has been denied access to your data.
any help on what is going on here?
Hello,
It's possible that during the authentication process, the Deny button was clicked instead of the Allow button, which enables the add-on to work.
Try removing the add-on and then adding it back again. To remove it, go to the Google form and select Add-Ons > Manage Add-Ons > Manage (next to the Smartsheet add-on) > Remove
Then download it again from the google add-on store and see if you can authenticate.
If that doesn't work, please reach out to our Support team to troubleshoot further.
I have just tried to do the above. I try to sync and I get the access denied. I have removed the add-on, shut down the browser and repeated the whole process again - being careful to ensure I don't hit deny, but I still cant sync.
I have a report that beautifully aggregates data from 70+ sheets. I need one column from that report to populate a helper sheet that I have: Source Sheets > Report > Helper Sheet As the report grows with data, I want the helper sheet to grow with it without manual intervention. Ergo, the API question. Here's what I know…
We're looking to create a Gantt chart by inserting the data and creating the chart via the API (actually via the Java SDK, but either will do). Inserting the data is fine, but cannot seem to get the setDependenciesEnabled (which believe need for the Gantt ) or setGanttEnabled() to work… We think part of this is the order…
Hi, Since yesterday (dec 18), many calls to the api are failing or taking way longer than expected (2500seconds to read a sheet). What is the current server status and when should it be back to normal ?