Import Member Posts with Zapier


This article shows an example on how to import member posts using Zapier.

It is also possible to import posts via CSV and API.

In this instance, we have an example file in CSV format. To enable Zapier to retrieve the data, the file needs to be uploaded to Google Sheets.

To understand the formatting of the CSV file please see: How To Import Posts Via CSV File

Note: When adding images to the file for upload, the image(s) can be added with the entire URL that includes the https protocols and website domain or just the relative URL.

e.g.: or /images/image.jpg

The image URL must also have a compatible extension: jpg, jpeg, png, gif, webp. 

The image must be publicly accessible (the host cannot block the image importer).

Once the data is on a Google Sheet file it is time to login to Zapier and create a Zap.

As a trigger select Google Sheets:

Under "Event" select New Spreadsheet Row:

Choose the Account.

Select the Spreadsheet.

Select the Worksheet.

Click on Test trigger.

Click on Continue.

For the Action Select Brilliant Directories Latest.

Select "Create Post".

Sign in to the account.

Enter the website URL and the Brilliant Directories API, to generate a new one please see:

Developer Hub ยป Generate API Key Overview

Click on Continue.

Select the Post Type, in this example it is Website Blog Article.

Select the "Post Author ID".

Select the "Post Title".

Select the "Post Feature Image".

Select Yes on Auto-Import Images. If Yes is selected, the system will import post images and save them to your website. Processing may take several minutes after import.

Select "Post Category".

Select "Post Tags".

Select "Post Location".

Select Yes to Use Google Maps To Geocode Post Location.

Allow Google to geocode posts. Requires "Pretty URLs with Google Maps". 

Click Continue.

Click Test Action.

Click Publish.

Once the Zap is published, go to My Content >> Manage Posts.

Look for the post type that should be imported on the dropdown and see the post imported.