--- title: "How to automate your event promotion with Zapier and ChatGPT" description: "Run your event promotion on autopilot when you combine the power of AI with automation." image: "https://images.ctfassets.net/lzny33ho1g45/2QTzx10CwjYZlFoG6C9jME/29a0a167cf9d5b66329f5655b8df7ccd/meta-automate-event-promotion-with-ai-00-hero.jpg" --- # How to automate your event promotion with Zapier and ChatGPT Run your event promotion on autopilot when you combine the power of AI with automation. Imagine a world where your event promotion runs almost on autopilot, where you can easily and automatically create messages tailored perfectly for each platform. Wouldn't that be better than spending hours manually crafting bespoke messages, scheduling timely posts, and juggling between tools?  With [Zapier and ChatGPT](https://zapier.com/apps/chatgpt/integrations), we can reduce what used to take hours down to less than 10 minutes. In this tutorial we'll walk you through a step-by-step process to automate your event promotion across [Facebook](https://zapier.com/apps/facebook-pages/integrations), [LinkedIn](https://zapier.com/apps/linkedin/integrations), and [Mailchimp](https://zapier.com/apps/mailchimp/integrations), all while saving you time and effort.  ## How it works For this project, we'll be using two Zaps to automate our event promotion. In our first Zap, we'll use OpenAI's ChatGPT to generate the content for a Facebook post, a LinkedIn post, and an email campaign promoting our event. Once this content is generated, you'll have a chance to manually review and edit the content before it's sent.  Then, in our second Zap, we'll automatically create and send the Facebook post, LinkedIn post, and email campaign. Before we begin developing our Zap, you'll also need an OpenAI account if you don't already have one. Go to [platform.openai.com](https://platform.openai.com/) to sign up for your account. You'll also need a Facebook Page, a LinkedIn account, and a Mailchimp account. If you use different social and email apps, don't worry. These same steps will work with any [social or email marketing apps that connect with Zapier](https://zapier.com/apps). Are you ready to build this yourself? Let's get started! ## Build Zap 1 to generate post and email content In this first Zap, we'll be automating the process to generate a Facebook Post, a LinkedIn Post, and an email using ChatGPT. When the Zap runs, ChatGPT will add your social and email posts to Google Sheets, where you can then review them before publishing. ### Step 1: Set up your Google Sheets trigger step To start, you'll need to create a new Google Sheet that includes all of the relevant details for the events you'll be promoting. Give your sheet a descriptive name. I called mine **Event Promotion**. Create 11 columns, with the following names: 1. Event 2. Date 3. Time 4. Location 5. Details 6. Generate Posts 7. Facebook Post 8. LinkedIn Post 9. Email Message 10. Email Subject 11. Send Posts Fill in the details for an event in the first five columns, by providing the event name, date, time, location, and some descriptive details. For this example, I'm going to be promoting a Zapier ChatGPT webinar.  Here's what my Google Sheet looks like with the relevant fields completed: In the _Generate Posts_ and _Send Posts_ fields, add a checkbox by navigating to **Insert > Checkbox** in the menu. By using checkboxes, we'll be able to edit our content until we're ready, and then use checking the box to trigger our Zap to run.  Once you have all the details filled in for your event, check the **Generate Posts** checkbox. Head over to Zapier, and click the **Create Zap** button to [create a new Zap](https://zapier.com/editor).  Search for and select **Google Sheets** for the trigger app and **New or Updated Spreadsheet Row** for the trigger event.  Next, connect your Google account to Zapier, if you haven't already. In the _Spreadsheet_ field, search for and select the **Event Promotion **sheet you just created. Leave _Sheet1_ in the worksheet field, and select **Generate Posts** as the trigger column to ensure this Zap is only triggered for changes to that field. Here's how the trigger will look: Click **Test Trigger**, and you should see your event details from the Google Sheet, as shown below: ### Step 2: Set up a filter step for the Generate Posts checkbox Click the **+** symbol beneath your Google Sheets trigger, then select **Filter** for the action app.  In the filter fields, select **Generate Posts** from your Google Sheets trigger and select the option **(Boolean) is true** in the filter dropdown: This filter will ensure this Zap only runs when the **Generate Posts **checkbox has been checked. Test this action step to ensure the filter is working properly for your record. Next, we'll work on setting up our prompts to send to ChatGPT. ### Step 3: Set up your action to Generate Facebook Posts with ChatGPT If you haven't set up your Zapier connection to OpenAI, you'll have to do that now. To start, head back over to [platform.openai.com](http://platform.openai.com) to log into your account. At the top right of the page, click on your profile icon and click **View API Keys**: From that page, click the **+ Create new secret key button** to generate a new API key. You'll need this key to connect to your OpenAI account within Zapier. Copy this key and store it somewhere safe. Head back over to Zapier and add a new action step at the bottom of your Zap. Search for the **ChatGPT** app and choose the **Conversation** event: Click on **Choose account**, and set up a new account by providing the API key you just generated in OpenAI. If you already have set up your account connection, simply select your existing account. Head to the _Action_ section to build the message we'll be sending over to OpenAI. In the _Message_ field, copy and paste the following:  _Generate the text for a Facebook post notifying my followers about this event. This post should be brief but compelling and should encourage people to attend the event. _ `Event Title:  ` `Event Date & Time:  ` `Event Location:  ` `Event Details:  ` Replace the bracketed content with the mapped fields from your Google Sheets trigger by selecting those fields from the _Insert Data_ dropdown. If you have access to the **gpt-4 model**, select that in the _Model_**_ _**dropdown. Otherwise, you can keep **gpt-3.5-turbo**. Leave all the remaining fields as-is.  Here's how your action step should look: If you want, you can give more specific instructions in the User Message depending on your use case. For example, if you're using this for work events, you might provide some more context about your company and position that could be helpful for generating the posts and emails. For now, we'll keep it simple with the message I show above. Click **Test Action** to send the message over to ChatGPT. Review the summary and make sure everything looks okay.  ### Step 4: Save the generated Facebook Post text to your Google Sheet Next, we'll set up the action step that will save the Facebook Post that ChatGPT generated to your _Event Promotions_ Google Sheet. Add an action step and search for the **Google Sheets**_ _app. Select the **Update Spreadsheet Row** event: Search for and select the **Event Promotion **spreadsheet again, and in the _Row_ field, select **row ID** from your Google Sheets trigger from the _Insert Data _dropdown to ensure you're adding the generated post to the correct row once you have multiple events in your Google Sheet.  Your action step will look like this: Finally, in the _Facebook Post_ field, map the **Reply** from your ChatGPT action step which contains the generated Facebook Post text: This will add the generated Facebook Post to your Google Sheet, which you'll later be able to review before posting. Next, click **Test Action** to send the Facebook post text to your Google Sheet and make sure everything is working properly.  ### Step 5: Set up your action to Generate LinkedIn Posts with ChatGPT The process for generating both LinkedIn posts and email messages is very similar to what we just did for the Facebook Post. Let's start here with the LinkedIn post.  Add a new action step at the bottom of your Zap. Search for the **ChatGPT** app and choose the **Conversation** event: Next, go to the _Action_ section to build the message we'll be sending over to OpenAI. In the _Message_ field, copy and paste the following:  _Generate the text for a LinkedIn post notifying my followers about this event. This post should be brief but compelling and should encourage people to attend the event. _ `Event Title:  ` `Event Date & Time:  ` `Event Location:  ` `Event Details:  ` Replace the bracketed content with the mapped fields from your Google Sheets trigger by selecting those fields from the _Insert Data_ dropdown. As before, if you have access to the **gpt-4** model, select that in the _Model_**_ _**dropdown. Otherwise, you can keep **gpt-3.5-turbo**. Leave all the remaining fields as-is.  Here's how your action step should look: Click **Test Action** to send the message over to ChatGPT. Review the summary and make sure everything looks okay.  ### Step 6: Save the generated LinkedIn post text to your Google Sheet As with the Facebook post, we'll set up the action step that will save the LinkedIn post that ChatGPT generated to your _Event Promotions_ Google Sheet. Add an action step and search for the **Google Sheets**_ _app. Select the **Update Spreadsheet Row** event: Search for and select the **Event Promotion **spreadsheet again and in the _Row_ field, map the **row ID** from your Google Sheets trigger to ensure you're adding the generated post to the correct row once you have multiple events in your Google Sheet. Your action step will look like this: Finally, in the _LinkedIn Post_ field, map the **Reply** from your ChatGPT action step which contains the generated LinkedIn Post text: This will add the generated LinkedIn post to your Google Sheet, which you'll later be able to review before posting. Next, click **Test Action** to send the LinkedIn post text to your Google Sheet and make sure everything is working properly.  ### Step 7: Set up your action to Generate email messages with ChatGPT Next, we'll follow the same process to have ChatGPT generate our promotional email message. Add a new action step at the bottom of your Zap. Search for the **ChatGPT** app and choose the **Conversation** event: Next, go to the _Action_ section to build the message we'll be sending over to OpenAI. In the _Message_ field, copy and paste the following:  _Generate the text for an email notifying my followers about this event. This email should be brief but compelling and should encourage people to attend the event. _ `Event Title:  ` `Event Date & Time:  ` `Event Location:  ` `Event Details:  ` Replace the bracketed content with the mapped fields from your Google Sheets trigger by selecting those fields from the _Insert Data_ dropdown. As before, if you have access to the **gpt-4** model, select that in the _Model_**_ _**dropdown. Otherwise, you can keep **gpt-3.5-turbo**. Leave all the remaining fields as-is.  Here's how your action step should look: Click **Test Action** to send the message over to ChatGPT. Review the summary and make sure everything looks okay.  ### Step 8: Save the generated email message text to your Google Sheet Now we'll set up the action step that will save the email that ChatGPT generated to your _Event Promotions_ Google Sheet. Add an action step and search for the **Google Sheets**_ _app. Select the **Update Spreadsheet Row** event: Search for and select the **Event Promotion **spreadsheet again and in the _Row_ field, map the **row ID** from your Google Sheets trigger to ensure you're adding the generated email to the correct row once you have multiple events in your Google Sheet. Your action step will look like this: Finally, in the _Email Message_ field, map the **Reply** from your ChatGPT action step which contains the generated Email text: This will add the generated email to your Google Sheet, which you'll later be able to review before posting. Next, click **Test Action** to send the email text to your Google Sheet and make sure everything is working properly.  You've finished the first Zap, which will automatically generate Facebook and LinkedIn posts, plus an email to promote your events. You should see your Google Sheet populated, similar to this: At this point, you should manually review and edit the contents in the **Facebook Post**, **LinkedIn Post**, and **Email Message** fields.  You should also add a subject to the **Email Subject** field, which ChatGPT has likely already created for you in the **Email Message** field. Once you've finished any edits and you're ready to send these posts out, check the **Send Posts** checkbox.  Now we're ready to move onto our second Zap! ## Creating Zap 2 to send posts and emails In this second Zap, we will automate the process of sending out our Facebook and LinkedIn posts as well as a Mailchimp campaign.  Are you ready? Let's get building! ### Step 1: Set up your Google Sheets trigger step Head back to your Zapier homepage and click the **Create Zap** button to [create a new Zap](https://zapier.com/editor).  Search for and select **Google Sheets** for the trigger app and **New or Updated Spreadsheet Row** for the trigger event.  Next, connect your Google account to Zapier, if you haven't already. In the _Spreadsheet_ field, search for and select the **Event Promotion **sheet you just created. Leave _Sheet1_ in the worksheet field, and select **Generate Posts** as the trigger column to ensure this Zap is only triggered for changes to that field.  Here's how the trigger will look: Click **Test Trigger**, and you should see your event details from the Google Sheet, as shown below: ### Step 2: Set up a filter step for the Send Posts checkbox Click the **+** symbol beneath your Google Sheets trigger, then select **Filter** for the action app.  Then select **Send Posts** from your Google Sheets trigger and select the option **(Boolean) is true** in the filter dropdown: This filter will ensure this Zap only runs when the **Send Posts **checkbox has been checked. Test this action step to ensure the filter is working properly for your record. Next, we'll work on automatically posting the results to Facebook, LinkedIn, and Mailchimp. ### Step 3: Create a Page post in Facebook Pages Add a new action step at the bottom of your Zap. Search for the **Facebook Pages** app and choose the **Create Page Post** event: Connect your Facebook account and then select the Facebook Page you want to send your posts to. Click in the _Message_ field, then select **Facebook Post** from your Google Sheets trigger step from the _Insert Data_ dropdown.  Your action will look like the following: Test your action to make sure everything is working properly. If you navigate to your Facebook Page, you should see a new post advertising your event, similar to the one that I have below: ### Step 4: Create a Company Update in LinkedIn Add a new action step at the bottom of your Zap. Search for the **LinkedIn** app and choose the **Create Company Update** event: Connect your LinkedIn account and then select the LinkedIn Company Page you want to send your posts to. In the _Update Content_ field, map the **LinkedIn Post** from your Google Sheets trigger step. Your action will look like the following: Test your action to make sure everything is working properly. If you navigate to your LinkedIn Company Page, you should see a new post advertising your event, similar to the one that I have below: ### Step 5: Create a campaign in Mailchimp Next, we'll automate the process of sending our email to our audience in Mailchimp. This will require 2 steps. First, we'll have to create a new Campaign in Mailchimp, where we'll select our audience and build our email. Second, we'll tell Mailchimp to send the email Campaign we've just created. Add a new action step at the bottom of your Zap. Search for the **Mailchimp** app and choose the **Create Campaign** event: Connect your Mailchimp account. In the _Campaign_ field, map the **Event** name from your Google Sheet trigger step.  In the _Audience _field, select the Mailchimp audience you're targeting for this event.  In the _Email Subject_ field, map the **Email Subject** from your Google Sheet trigger step. Fill in the _From Name_ and _From Email Address_ fields with your name and email. Finally, in the _Email Content (HTML) _field, map the **Email Message** from your Google Sheet trigger step. Your action step will look like this: Test your action to make sure everything is working properly. ### Step 6: Send a campaign in Mailchimp Finally, we'll send out our email Campaign via Mailchimp. Add a new action step at the bottom of your Zap. Search for the **Mailchimp** app and choose the **Send Campaign** event: In the _Campaign _field, map the **ID** from your prior Mailchimp action step, which corresponds to the email Campaign you just created. Finally, test your action to make sure everything is working properly.  If you navigate to your email, you should see a new message advertising your event. If everything looks correct, you're ready to publish your Zaps! # Putting it all together You now have a process that you can use to automatically generate and send Facebook posts, LinkedIn posts, and Mailchimp email campaigns to promote your upcoming events!  Here's how you can work this process end-to-end: 1. Fill in the relevant details for your event in the **Event**, **Date**, **Time**, **Location**, and **Details **columns of your Google Sheet 2. Check the **Generate Posts** checkbox. Your first Zap should now trigger and automatically add the ChatGPT posts to the **Facebook Post**, **LinkedIn Post**, and **Email Message** fields in your spreadsheet. 3. Edit the posts and email messages and add your **Email Subject**. 4. Check the **Send Posts **checkbox. Your second Zap should now trigger and automatically send your edited posts to your Facebook Page, LinkedIn Company Page, and Mailchimp audience. With this process, what may have previously taken you a few hours of work you've now condensed down to only the couple of minutes it takes to fill in your Google Sheet and make quick edits to the content that ChatGPT generated. Now get out there and promote your events!