How to import information to a Pipe using Zapier and Google Sheets!
Wouldn’t it be great if there was a way you could import information into your pipes from, let’s say, a spreadsheet and create one or more cards from the lines of said spreadsheet?
First of all, why would I use this integration?
Let’s consider you’ve just started using Pipefy and you want to migrate the information you controlled previously by using simple spreadsheets or other task/project management apps that allow you to export the information.
Think about how much work it would be to manually create cards with all that information…that’s boring, right? And who has time for all that? Well, if you use this simple integration that allows you to import information, you don’t need to spend a second longer thinking about that!
All you’ll need is your Pipefy account, a Google Sheets spreadsheet and a Zapier account. There’s no hard work involved in setting up the integration either! Once you inform Zapier which information from the spreadsheet you want to be included on each field of the cards, that’s it, Zapier does all the hard work!
Ok, but what is Zapier?
Zapier is a cloud application that allows you to optimize and automate your processes by connecting over 500 webapps in thousands of different possibilities.
Each zap (integration) on Zapier consists on a trigger (the activity/situation that sets your zap in motion – in the case of this integration, adding one or more lines of information to a spreadsheet) and an action (what happens once the trigger is, well, triggered, aka creating one or more cards on Pipefy with the information from the spreadsheet).
That’s cool, but how can I integrate Pipefy to all those apps using Zapier?
Using Zapier to integrate Pipefy with hundreds of web apps is a lot easier than you think (really, even I could do it!), here’s what you must do:
We’ll include the complete step-by-step instructions on how to setup this integration below but to kick things off you can choose to use this pre-designed integration available on Pipefy’s Zapier zapbook and specify the details according to the instructions below.
How to create this integration to import information?
As previously explained, all integrations on Zapier work with based on a trigger and an action app.
1 – To begin with, you’ll click on the button that says “Make a Zap” on your dashboard on Zapier.
2 – Then, the first step for creating an integration is choosing Google Sheets as your trigger app.
I had already added my account so all I had to do was select it.
This time you’ll search for and choose Pipefy from all the available action apps.
This part is easier because “create new card” is the only option available.
If you have any question regarding how to add your Pipefy account to Zapier, click here and check out the help content on the subject.
Pay attention, however, that due to the fact that we’re using a free account, information will be retrieved from the spreadsheet every 15 minutes so the updates won’t happen instantly.
How awesome is that?