How to Add a Post to Google Sheets When It Is Published in WordPress

[What is Yoom]

How to Create a Workflow to Integrate WordPress and Google Sheets

Let's create a flow together using a template to "add to Google Sheets when a post is published on WordPress"!

Step 1: Connect WordPress and Google Sheets to My Apps

(1) After logging into Yoom, select "My Apps" from the left column and click "+ New Connection".

(2) From the list of new connections in My Apps, click WordPress.
(3) On the "New WordPress Registration" screen, enter the account name, access token, and domain, then click "Add".
※ It is recommended to connect with a site that has SSL settings, so please proceed while checking the red frame for some precautions.
※ For how to obtain an access token, please refer to the following site.‍

What is Base64 Encoding

(4) Next, connect Google Sheets. Similarly, click Google Sheets from the list of new connections in Yoom.
(5) Click "Sign in with Google".

Once the connection is complete, WordPress and Google Sheets will be registered in Yoom's My Apps.
This completes the My Apps registration.
Next, let's set up the trigger using a template!

Step 2: Set Up App Triggers

(1) We will use the template introduced earlier. Please click "Try it" on the banner below.

Click on "When a post is published" in the app trigger.

(2) From the "Select integration account and action" screen in WordPress, check if there are any errors in the account information linked with WordPress, keep the trigger action as "When a post is published," and click "Next."

(3) From the "App Trigger API Connection Settings" screen, select the trigger activation interval from the dropdown.
※ The trigger activation timing can be set to 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. The shortest interval that can be set depends on your plan, so be sure to check this. It is generally recommended to use the shortest activation interval available in your plan.

Once the selection is complete, click "Test," and if no errors occur, click "Save."

Step 3: Add to Google Spreadsheet

(1) Next, operate the Google Spreadsheet database.
Click "Add record."

(2) From the "Database Integration" screen in Google Spreadsheet, check if there are any errors in the account information linked with Google Spreadsheet, and keep the execution action as "Add record."

Scroll down, select the spreadsheet ID and tab name from the options, and directly input the table range.

Once the input is complete, click "Next."
(3) From the "Detailed Settings for Database Operations" screen, select the record values for each item from the output.

Once the input is complete, click "Test" at the bottom, and if no errors occur, click "Save."

(4) Finally, click "Turn on Trigger."

This completes the flowbot for "Add to Google Spreadsheet when a post is published on WordPress."

Other Automation Examples with WordPress and Google Spreadsheet

In addition to the flow introduced this time, you can achieve various business automations using the APIs of WordPress and Google Spreadsheet. All of them can be used with simple settings, so if you find something interesting, please give it a try!

Examples of Automation Using WordPress

1. Notify Google Chat When an Article is Published on WordPress

This will be useful for those who want to smoothly share publication information with team members and stakeholders.

2. Add to kintone when a post is published on WordPress

This is recommended for those who want to reduce the effort of manually syncing article information between WordPress and kintone.

3. Notify Slack When a Comment is Added in WordPress

Every time a comment is added, it will be sent to Slack, making it ideal for those who want to quickly understand the reaction to their articles.

Automation Example Using Google Sheets

1. Send an Email via Gmail When a Row is Added in Google Sheets

This is recommended for those who want to reduce the effort of manually creating emails or who use Gmail for business communication.

2. When a row is added in Google Sheets, create a folder in Google Drive

This is recommended for those who want to manage the contents of Google Sheets collectively in Google Drive.

‍

3. Add information added to NotionDB to Google Sheets as well

This is recommended for those who use both Notion and Google Sheets for data management.

Benefits of Integrating WordPress with Google Sheets

Benefit 1: Reduction of Manual Input

By integrating WordPress with Google Sheets, you eliminate the need for manual data entry related to posts. For example, information such as the title, URL, and publication date can be automatically reflected in the spreadsheet each time an article is published. This saves time and helps prevent input errors.
This automation allows team members to focus on more important tasks, potentially increasing overall work efficiency. This is particularly beneficial for media operators and bloggers who frequently publish articles.

Benefit 2: Easier Analysis with Centralized Content Management

Integrating WordPress with Google Sheets makes it easier to centrally manage data such as publication dates, categories, and view counts for each article using Google Sheets. Flexible analysis becomes possible, allowing you to easily understand how specific themes or article types are performing, which can be useful for SEO and marketing strategies. For marketers and SEO specialists, centralized data management supports the development of more effective strategies.

Conclusion

Integrating WordPress with Google Sheets not only reduces the hassle of manual input but also helps improve the efficiency of data management!
This is a significant benefit, especially for media operators who frequently publish articles and marketers who prioritize data analysis.
With Yoom, you can easily create integration flows without any programming knowledge.
Use this article as a reference to aim for improved work efficiency with Yoom!