Step 2: Connect WordPress (HTTP Basic Auth)

HTTP requests pull posts, categories, tags, and media from WordPress. Each request uses HTTP Basic Authentication.

1. In Fetch WP Articles, set URL to {{$json.base_url}} and enable Send Query.
2. Set query parameters in Fetch WP Articles to: per_page={{$json.per_page}}, page={{ $json.current_page }}, _embed=wp:featuredmedia,wp:term, _fields={{$json.fields}}, orderby=date, order=desc.
3. Credential Required: Connect your httpBasicAuth credentials in Fetch WP Articles.
4. In Retrieve WP Categories set URL to https://ozwebexpert.com/wp-json/wp/v2/categories and keep Execute Once enabled.
5. Credential Required: Connect your httpBasicAuth credentials in Retrieve WP Categories, Fetch Media Library, and Fetch WP Tags.
6. In Fetch WP Tags confirm the URL is https://ozwebexpert.com/wp-json/wp/v2/tags with query parameters per_page=100 and _fields=id,name,slug.

Step 3: Set Up Paging and Post Sync Logic

This section initializes paging variables, fetches posts in pages, and keeps iterating until all pages are processed.

1. In Init Page Variables, set JSON Output to { "base_url": "https://ozwebexpert.com/wp-json/wp/v2/posts", "fields": "id,slug,link,date,title,excerpt,categories,tags,featured_media,_embedded", "per_page": 10, "current_page": 0 }.
2. Keep the code in Advance Page Counter as-is to increment current_page for each loop.
3. Connect Advance Page Counter to Fetch WP Articles so each increment fetches a new page of posts.
4. In Expand Post Items, set Field to Split Out to body and Include to allOtherFields.
5. In Page Limit Check, keep the condition comparing {{ $('Advance Page Counter').item.json.current_page }} to {{ $('Fetch WP Articles').item.json.headers['x-wp-totalpages'] }} to stop looping at the last page.

Page Limit Check outputs to both Retrieve WP Categories, Init Media Variables, and Fetch WP Tags in parallel.

Step 4: Configure Media and Tag Sync Branches

Two additional branches pull media and tag data and iterate through their pages independently.

1. In Init Media Variables, set JSON Output to { "base_url": "https://ozwebexpert.com/wp-json/wp/v2/media", "per_page": 10, "current_page": 0 }.
2. Keep the code in Advance Media Counter to increment current_page for media pagination.
3. In Fetch Media Library, set URL to {{$json.base_url}} with query params per_page={{ $json.per_page }}, page={{ $json.current_page }}, and parent_exclude=0.
4. In Expand Media Items, set Field to Split Out to body.
5. Keep the Media Page Check condition comparing {{ $('Advance Media Counter').item.json.current_page }} to {{ $('Fetch Media Library').item.json.headers['x-wp-totalpages'] }} for loop control.
6. In Expand Tag Items, set Field to Split Out to body to unpack tag results from Fetch WP Tags.

Step 5: Configure Google Sheets Output Nodes

Each dataset is appended or updated in its own sheet using matching IDs.

1. In Sync Posts Sheet, keep Operation set to appendOrUpdate, Document ID set to https://docs.google.com/[YOUR_ID], and Sheet Name set to Posts.
2. Map columns in Sync Posts Sheet to the post fields, such as id={{ $json.body.id }}, title={{ $json.body.title.rendered }}, and categories={{ $json.body.categories[0] }}.
3. In Sync Category Sheet, keep Operation set to appendOrUpdate, Sheet Name set to Categories, and match on category_id.
4. In Sync Media Sheet, keep Operation set to appendOrUpdate, Sheet Name set to Media, and map values like url={{ $json.source_url }} and media_id={{ $json.id }}.
5. In Sync Tag Sheet, keep Operation set to appendOrUpdate, Sheet Name set to Tags, and match on tag_id.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Sync Posts Sheet, Sync Category Sheet, Sync Media Sheet, and Sync Tag Sheet.

⚠️ Common Pitfall: Ensure each Google Sheet has the exact column headers defined in the node mappings (e.g., id, category_id, tag_id, media_id) or append/update will not match correctly.

Step 6: Test and Activate Your Workflow

Validate that each branch runs and writes data to your Google Sheets before enabling the schedule.

1. Click Execute Workflow to test with the Scheduled Run Trigger or send a request to the Incoming Webhook Trigger URL.
2. Confirm that Sync Posts Sheet, Sync Category Sheet, Sync Media Sheet, and Sync Tag Sheet each append or update rows in your target spreadsheet.
3. Verify that Page Limit Check and Media Page Check stop looping after the final page based on the response headers.
4. Once verified, toggle the workflow to Active to enable scheduled runs in production.