Skip to main content

Scrape blogs from web using Zapier and rewrite blogs using chatgpt

In this tutorial, we will create a custom web scraping automation using Zapier. This setup allows you to scrape content from various websites, rewrite it, and then repost it on your own blogging platform. Not only is this process straightforward, but it also offers a potential way to earn money through blogging without the need for a dedicated content writer. Let’s jump right in!

Zapier Dashboard
Zapier Dashboard

Step 1: Prepare Your Spreadsheet

Before we dive into Zapier, make sure you have a spreadsheet ready. This spreadsheet will contain the URLs of the websites from which you want to scrape content. For example, you might include a URL from your own blog or another relevant site.

Step 2: Create a New Zap

  1. Log in to Zapier: Start by logging into your Zapier account.
  2. Create a New Zap: Click on the “Create Zap” button to begin setting up your automation.

    Create Zap
    Create Zap

Step 3: Set Up the Trigger

  1. Choose App: Select Google Sheets as your trigger app.
  2. Select Trigger Event: Choose New or Updated Spreadsheet Row. This means that every time you update a row in your spreadsheet, the automation will run.

    Setting Trigger
    Setting Trigger
  3. Connect Your Account: If you haven’t already, sign in to your Google Sheets account and authorize Zapier.
  4. Configure Trigger: Select the spreadsheet you prepared earlier (e.g., “Scraping Demo”) and choose the worksheet containing your URLs. Set the trigger column to the URL column.

    Configure Trigger
    Configure Trigger

Step 4: Test the Trigger

  1. Add a URL: Copy and paste a URL into the designated column in your spreadsheet.
  2. Test Trigger: Click on “Test Trigger” to ensure that Zapier can detect the URL you just added. If successful, you should see the URL and its associated row ID.

    Testing Trigger
    Testing Trigger

Step 5: Parse the Web Page

  1. Add Action: Now, add a new action by selecting Web Parser from Zapier’s options.
  2. Select Event: Choose Parse Web Page.

    Adding Parse Action
    Adding Parse Action
  3. Configure Action: For the URL, select the URL you retrieved from the spreadsheet. Choose Markdown as the content output format, which is a great option for formatting text.

    Configure Parse Module
    Configure Parse Module
  4. Test the Parsing: Click on “Test Action” to see if Zapier successfully scrapes the content from the specified URL. You should see the raw content extracted from the web page.

    Testing Parser
    Testing Parser

Step 6: Update the Spreadsheet with Raw Content

  1. Add Another Google Sheets Action: Now, add another action to update the spreadsheet with the scraped content.
  2. Select Event: Choose Update Row.

    Update Spreadsheet Row Module
    Update Spreadsheet Row Module
  3. Configure Action: Select the same spreadsheet and worksheet. Choose the row number that corresponds to the URL you scraped.
  4. Map the Data: For the value you want to update, select the content you just parsed from the web page.

    Configuration and Mapping
    Configuration and Mapping

Step 7: Rewrite the Content Using ChatGPT

  1. Add ChatGPT Action: Next, add an action for ChatGPT by selecting it from the app list.
  2. Select Event: Choose Have a Conversation.

    Adding Chatgpt Action
    Adding Chatgpt Action
  3. Configure Action: In the prompt section, craft a thoughtful prompt to rewrite the scraped content. For example, you might say, “You are an expert content writer. Rewrite the following blog in a more conversational tone: [insert scraped content].”
  4. Select Model: Choose the model you want to use, such as GPT-3.5 or GPT-4.

    Configuring Chatgpt
    Configuring Chatgpt

Step 8: Update the Spreadsheet with Rewritten Content

  1. Add Another Google Sheets Action: Add a final action to update the spreadsheet with the rewritten content.
  2. Select Event: Choose Update Row again.

    Output Spreadsheet Update
    Output Spreadsheet Update
  3. Configure Action: Select the same spreadsheet and worksheet. Choose the same row number.
  4. Map the Data: This time, select the rewritten content from the ChatGPT response and map it to the appropriate column in your spreadsheet.

    Mapping Output
    Mapping Output

Congratulations! You’ve successfully set up a custom web scraping automation that scrapes content from websites, rewrites it, and stores both versions in a Google Sheet. This automation not only saves you time but also allows you to generate content for your blog or other platforms efficiently.

0
    0
    Your Cart
    Your cart is emptyReturn to Courses