If you're looking to create content requests without having to access the customer dashboard, or if you're interested in automating your content requests, then look no further! Here's how you can use Google Sheets to automatically request content.
REMINDER: You will need your own Zapier account before getting started with the integration.
How to Set Up the Google Sheets Integration
In Google Sheets, create a spreadsheet following the example below. Or, you can make a copy of our template saved here.
You'll treat each row as a separate brief/request. The columns reflect the fields of our briefs on the platform, and each time you populate a new row, a brief will automatically be created on our platform. So, you don't have to log in to request content!
REMINDER: Row 2 is provided as an example of what your request could look like, so be sure to delete it when you save your own template!
Log in to your Zapier account.
Create a new Zap.
Select the trigger to be Google Sheets - New Spreadsheet Row and the action to be ContentFly - Request an Article.
Follow the steps to connect your Google account (if not already connected) and select the spreadsheet and specific worksheet (tab) to use.
To connect your Contentfly account, you'll need to log in to your Contentfly dashboard, navigate to My Account, and select Integrations. To create a new API key, type Zapier Key (or another description to act as the title for the key) and click Create new API key. A pop-up with your secret API key will appear.
Go back to the Zapier pop up window and input the new API key in Contentfly as the Id and put in the secret key under Secret to finish the connection.
REMINDER: the Secret only shows once so be sure to save it somewhere!
Select the Contentfly brief fields that you will be providing and check them off. Make sure all required fields are selected as well as the other fields you plan to include!
Now you'll need to map the columns of the spreadsheet to the selected properties on the platform. They're named exactly the same to make it easy (they should auto-populate)!
REMINDER: the type (format) is a fixed value and you need to select it from the drop-down (i.e. Article, Landing Page Copy, etc.)
Test the Zap and confirm that a request is created in your platform account (this can take up to 5 minutes).
Now you're all set and can turn on the Zap to start requesting content automatically from Google Sheets!