Connections to Google Sheets

excel

#1

I love the functionality of using excel spreadsheets to drive my applications in Intuiface. Any possibility to allow connections with Google spreadsheets as an interface asset? This would allow cloud updates to the app in real time with multiple users editing!


#2

Vote for this idea:

  • Yes
  • No

0 voters


#3

This would be EXTREMELY useful!


#4

Yes PLEASE :slight_smile:


#5

Any hope?


#6

Up! We’d love it!


#7

Actually, this is already possible with the creation of custom Interface Asset using a REST Api and a third party tool like Sheetsu. Creating these Interface Assets on the fly will be much easier with 6.0.

Another tool that we like a lot is Airtable. You can see how we used it in the Task board sample in this article section.


#8

Seb I was thinking that since Excel has such powerful manipulation tools that some API’s don’t provide (such as filtering, searching, etc)

It would be REALLY cool if there was an Interface Asset “Excel-Connector” that could ‘read’ in data from an api into the cells of a local excel file. Then the designer could use that excel file for regular manipulations. Just pull any parameters in, and design-out what you need.

I assume the connector would need to lock the excel file from the user as well, so adding/editing rows on the fly might be overwritten by the API or crash excel if something is accidentally renamed.

Curious about your thoughts on this. It seems the API explorer prepares the data nicely enough that this could be done?


#9

Actually, we have another idea in mind which would be to bring the filtering / sorting mechanisms available to any REST based Interface Asset. That would let you download all the content you need using the API Explorer, then do the processing locally on the client side.

Regarding your idea, I think you can already do that with the API Explorer + add row feature of Excel. You could implement a kind of routine based on triggers & actions that would clear the excel file / refresh the data retrieved from the REST Interace Asset / fill the Excel file with that information.


#10

Seb, that’d be awesome to have those sorting/filtering abilities directly from the API data. How awesome. Then you’d be manipulating live data. Lots of possibilities, and it would make it easier to use the awesome powers of Airtable and others.

In the mean time, thanks for the suggestions on running the Add Row to an Excel doc. Though it could take a little bit, it could be a solution to hold us over until the api filter/sorting is released. Much appreciated as always.


#11

Seb,
Just a quick question about adding each row of the API data into the Excel doc…

As far as I can see, I would actually need to create a collection of the API data, then set a timer or counter to go through each record of that collection, and add that specific row. (It’d be nice if I could increment the record without creating a visible collection, but it doesn’t appear that I can automatically increment or manipulate the record numbers shown when binding to the API. For example, when using the Add Row, and binding to my Airtable API items, I can see that I’m viewing the first of 11 records, but I can’t automate the ability to go to the next record and add that row)

Also along these lines, there doesn’t appear to be any way to grab the total number of records from the API or the collection it feeds into. It’s not super necessary, but it could be useful.

I’ll keep working at it, but I was curious if there may be a different or easier way than I’m approaching this method.

**Update: I’m not sure this is actually possible anymore without the ability specify the record number to be updated from within the API data.

The only way I can see to sequentially update each item from API data into each row of excel is to create a button inside the API Data’s collection itself. The button inside the collection has an awareness of which record it is on, and therefore can add it’s own record data into a new row of excel. However, buttons inside collections cannot be triggered or manipulated, so there doesn’t appear to be any way to ‘automate’ this.


#12

Hi Alex,

You’re right, being able to bind the row number or item number in a feed is something we are still missing.

In your case, I’d do the following:

  • create an asset flow with a static item as item #1
  • add your data feed into this asset flow.
  • in the template, add an is moved into focus trigger that would call the excel action (with the right context) and call the next action on the asset flow
  • to start the routine, just call the scroll to item 2 on the asset flow to start with the first data feed item.

Because of the asset flow animation that can’t be changed, it’ll take some time to process the whole list (0.5s x number of items)


#13

Thanks Seb, I’ll give this a try and report back. If it works it may be Ok to set this up and run overnight or twice per day, at least until API data can be manipulated a little more.

I know there’s tons of new ideas and ‘wishes’ for the API data, but I hope your developers know how awesome the API builder is. It was probably a lot of work - they did a great job. It’s definitely sparked some serious interest in the community…and in my opinion may help position IF as a real major contender to browser based CMS’s.


#14

@Seb I have to laugh. I had another one of those moments reading your post.

I NEVER knew that the template within the data feed could call an action when it’s moved in or out of focus. In fact, I never looked there. I figured it had the same properties of every regular group. Nope. This is like a hidden little gem.

I’ve tested it out and it seems to work pretty well. Just need to work on some ways to optimize it a little bit and make sure it reliably enters all the data.

One thing I figured is that when users want to ‘update’ the list, all the data should probably be cleared out before new rows are added. To do this, I tied a simple countdown timer to the number of rows that get added into the excel spreadsheet. Start the countdown, and an action removes each row. Cleared and ready to enter new data.

Much appreciated.


#15

Hi Seb! I was wondering if there was any update with 6.0 that would allow us to use Google Sheets. Or if there was an example you could offer using Sheetsu and Google sheets?