All Collections
Technical & Security
Integrations
Zapier integration: Add campaign data to Google Sheets
Zapier integration: Add campaign data to Google Sheets

Add data to a Google Sheets document each time you publish a release

Naomi Chalmers avatar
Written by Naomi Chalmers
Updated over a week ago

Zapier is a tool that helps you automate repetitive tasks between two or more apps, without having to write code. When an event happens in one app, Zapier can tell another app to do a particular action (Zap). In this case, every time you publish a news article in the newsroom, we're adding the details of your release to a Google doc.

The setup is twofold: Make sure you've completed part 1, on our Zapier Integrations page and then you can complete the process with the instructions below. At this point you should be in the Set up Action section.

The setup:

1. From the list of apps, choose or search for Google Sheets.
​

2. In this article, we've chosen Create Spreadsheet Row, but here you could choose whichever action you prefer.

3. Next, you'll be asked to choose and log into the appropriate Google account. Click Continue.
​

4. If you don't have an existing Google sheets document that you'd like to use, now's the time to create one. Create a document, adding one row of headings, which should be the information you're collecting from the release. Read more about working with Zapier and Google Sheets.

5. Return to the Zap, and for each of your column headings, add the corresponding variable. We chose to include the release title, date, URL and reading time. This is our example.

6. Hit Continue and then Test Action.
​

7. Check your Google Sheets, and a new row should have been added.

8. Make any adjustments you need to in the previous step, and then publish your Zap!

And that's it!

Want to set up more Zaps? Check out these other options:

Questions❓

Should you run into any problems πŸ›‘ , bugs πŸ› , feature requests πŸ€” or have any questions πŸ€·β€β™‚οΈπŸ€·β€β™€οΈ , please get in touch with the pr.co support team. You can reach us either via the live chat or at hello@pr.co.

Suggested Reading πŸ“š

Did this answer your question?