andy_tillo952264

Create a quick Reminder App to save to Google Sheets with Flow!

Blog Post created by andy_tillo952264 Employee on Oct 9, 2017

There are several just whizbang features that people don't come to the Flow team to build as an enterprise. Oftentimes, it's just a quick tool that you wish you had in your tool belt that you can utilize and build on later. This was such a scenario, that worth a quick write-up to get your juices flowing (pun intended) on to what other sorts of things you can build! Ever wanted to just jot down a quick note or reminder and have it save to a Cloud location like Google Drive for edit later? Welp, you've come to the right place to set it up! We'll be building this super simple tool that goes from Flow-->AtomSphere-->Google Sheets: http://mwho.co/aQuickNote 

 

 

1. Create a Google Sheet

Well, first things first, create a Google Sheet that you want to edit via http://drive.google.com, and note the ID it creates (we'll use that later): 

 

2. Setup AtomSphere

1. Now we are going to set up AtomSphere to LISTEN for Flow to send it something...in this case we'll say it's "aQuickNote" variable that we want to post to that Google Sheet we just made. Go to AtomSphere and create a new Process: 

 

2. Set up the Connector to just listen in, like this: 

Note: You don't need a response profile, because we're not going to expect anything in return, we just want to SEND.

 

3. Configure it with the two variables Google cares about, the VALUE, and the SpreadsheetID: 

 

It should look super clean with your first shape like this: 

 

4. Add a Google Sheets connector shape: 

 

5. Create a new Google Connection if you don't have one already. For this example, we'll start from scratch and show you how to get one. You'll need an API key from Google, and they tell you how to get that HERE.

 

6. From the Credentials page, select your connection: 

 

7. Copy/paste your ClientID and Client Secret and paste those into your AtomSphere session:

 

When you click "Generate", Google will prompt you with a few things: 

And it'll give you this critical piece!  

 

NOTES: 

Note: This is generated by that callback URL when you put your BoomiID above! Make sure that's in there!

 

Note: You may get an error saying "invalid client" from AtomSphere, if so, make sure you copy/paste without a trailing space (like I just did [doh!]) --and put them back in there, click GENERATE again, and you should see: 

 

8. Now we've got a connection to Google, we just need to tell it what to DO once we send it the data:

 

9. Click the PLUS SIGN in the "Operation" field to create a new Operation.

 

10. This is where Boomi will do all the heavy lifting for you! Click "import":

 

11. Choose your Google Connection you just made: 

 

12. Insert that SheetID you created in Step #1!

 

 

13. Click next, and you'll be prompted like this (be sure to chose "Record data"):

 

14. AtomSphere will know to create the proper request and response profiles for you!

 

15. Click "Save and Close": 

 

16. Now create a map that sends the data the way that Google wants to see it!: 

 

 

 

17. Now you connect your shapes and deploy the process to production as well as updating the service to call it, like this: 

 

Your finished map should look about like this: 

 

3. Setup Flow

1. Create a new Service to send data to Atomsphere (if you don't already have it), like this: 

 

2. A lot is happening in this next slide, but the idea is that you want to grab your creds from your Atom in AtomSphere (Red arrows) and paste the creds in the corresponding (yellow arrows) fields: 

 

When you click "Continue" in Boomi Flow, take a look at the "Preview Actions and Types" and you'll see that it was added: 

 

Save that service with the password (repaste it) and click Save:

 

3. Now go import that Service into your flow: 

 

 

4. Now create a new "Page" from the left side (this is where we'll ask what we want to save there): 

 

5. Pull an "input" into the navigation pane: 

 

6. Map the value: 

 

7. Create a new value with what we want to send over to Google!

 

8. Save the value. Save the Page. Back to the main screen and drag the Start Shape to the New Page you just made: 

 

9. Now we gotta send that to Google, via the Service we just made above, so drag in a "Message" component: 

 

10. Set the values like this: 

 

 

 

 

 

 

 

 

11. Ok, now we tie them all together and click "Publish", cross our fingers, and...:

 

If all went as planned, you should see the same thing! Check it out: Boomi Flow to Google Docs! - YouTube 

 

Congrats, you just made a quick place to save notes in no time!

 

Extra credit: 

Let's clear out the variables that it saves, so it can be a clean slate every time!

 

Drag on an "Operator" in Flow, and configure it to set that value to "Empty" every time to loop back, like this: 

 

Let's see what that does now when the map looks like this: 

 

One more neat trick, it is mobile-friendly, out of the box!  See this --> Mobile (Boomi Flow) to Google Docs! - YouTube 

 

Congratulations, you just made a quick Reminder App via Boomi!

 

Ok, Ok, ONE more extra credit-worthy piece --How about a way to add-in and SEE your current list?  Easy enough, just drag in a new "Step" (See current list), and use an iframe to call the google sheet, like this:

 

 

Now it'll look like this from the "current" tab: 

Want to save this JSON for your own? Another fine aspect of Boomi Flow --Download the Flow config JSON file attached below and run it for yourself to see the magic!

 

Andy Tillo is a Boomi Sales Engineer for the Boomi Flow product based in Seattle, WA. I come from an infrastructure background, so it is nice to have something more code-based to sink my teeth into! Boomi Flow has been a great platform to get there!

Attachments

Outcomes