Connections to Google Sheets

@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.

2 Likes