Has anyone tried integrating Google Spreadsheets with Podio? Yes!
This thread was also on the old API developer forum on Gougle Groups. ( https://groups.google.com/forum/?fromgroups#!topic/podio-api/lRYSiUxPs2w)
Still it needs an answer though.
Apparently the implementation of oAuth by Podio is different then Google Apps Script with oAuthConfig expects.
I managed to make a work around by implementing my own method in Apps Script to work with oAuth.
What it does, is it shows a flowpanel with a link to Podio. (function authenticate()) Using that link you can authenticate. If you grant access, you get redirected to a simple html-page that shows another link. (function doGet(e))
Using that link you return to your spreadsheet, but now authenticated.
I didn't get much further than that. I created a simple function to get some data out of an app and dump it in a spreadsheet. If you would want this code to work for yourself you would have to edit this function, to reference one of your own podio apps:
function podioApiTest()
In the end it would be far easier if Podio could play well with oAuthConfig.
The enitre Google script is attached.
-
I have made some small improvements, after initial setup with the link, the script will refresh its token when it gets a 401 status code. You can easily filter that out.
Put your authentication token and refresh token in the Scriptproperties, and Google Apps is a damn easy way to get info out of Podio (and IN).
-
Hi Gijs,
We are working on the integration of Podio with Google Spreadsheets. We are doing well so far. We are able to import/export entire workspaces automatically with no clicks. Take a look at it and let us know your feedback.
http://www.nirvanabusinesssystems.com/optimize/podio-google-integration
Cheers,
Pablo.
-
Hi guys, the link above is old. I wanted to let you know we could integrate Podio and Google Spreadsheets. Here is a video we made:
http://www.youtube.com/watch?v=6xmWXis3mfs
Here the new link of the website as well:
http://www.nirvanabusinesssystems.com/spreadsheet-magic-podio-google-integration
Let us know what do you think and if you are still interested on that integration!
Cheers,
Pablo.
-
Hi there,
I'm quite interested in seeing this podioAPITest() script code... it does not seem to be attached to this post?? Well I managed to authenticate the google script as follows:
function PODIOMakeComment() {
var options =
{
"method" : "post"
};var result = UrlFetchApp.fetch("https://podio.com/oauth/token?grant_type=app&app_id=APPID&app_token=APPTOKEN&client_id=CLIENTID&redirect_uri=MYURL&client_secret=CLIENTSECRET",options);
Logger.log(result.getContentText());
var json = result.getContentText();
var data = JSON.parse(json);}
But then trying to use data.access_token as the token in an API call such as this one to get comments from an item gives a http 403 error, and I'm not sure why:
var headers2 =
{
"Authorization": "OAuth2 "+data.access_token,
"Content-type": "application/json"
};var url = "https://api.podio.com/comment/item/itemID/";
var options2 = {
//"contentType":"application/json",
"method": "get",
"headers": headers2
};
var response2 = UrlFetchApp.fetch(url,options2);Anyone have some ideas on this?
-
Pablo
I like your idea. I even paid for it. Now I want to use it and unfortunately your website is not active. Talk about tough timing. How can I get you to send it to me?
http://www.nirvanabusinesssystems.com/spreadsheet-magic-podio-google-integration
Please sign in to leave a comment.
Comments
15 comments