Step 2: Connect Google Sheets

Ensure the update operation can write back to the same spreadsheet after publishing.

1. Open Mark Sheet Row Completed.
2. Set Operation to appendOrUpdate.
3. Map status to Completed and post_id to {{ $('Select Latest Pending Row').item.json.post_id }}.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 3: Set Up Processing Logic

Filter pending rows and map the fields needed for publishing.

1. In Select Latest Pending Row, keep the provided JavaScript logic that filters status === "pending" and returns the latest row_number.
2. Configure Map Post Fields to assign caption to {{ $json.caption }}, image_url to {{ $json.image_url }}, and status to {{ $json.status }}.
3. Confirm the flow order: Pending Sheet Poller → Select Latest Pending Row → Map Post Fields.

Step 4: Configure the Meta Publishing Action

Publish the post to Meta using the Graph API and pass the mapped fields.

1. Open Publish to Meta API and set Edge to photos.
2. Set Graph API Version to v23.0 and HTTP Request Method to POST.
3. Set query parameters: url to {{ $json.image_url }} and caption to {{ $json.caption }}.
4. Credential Required: Connect your facebookGraphApi credentials.

Step 5: Configure Success/Failure Routing

Split the workflow based on the publish response and notify via Slack and email.

1. In Validate Publish Result, keep the condition post_id is not empty using {{ $json.post_id }}.
2. Note the parallel execution: Validate Publish Result outputs to both Slack Success Alert and Email Success Notice in parallel.
3. Configure Slack Success Alert with the message text =✅ Post successfully published to Meta! ... Post ID: {{ $json.id }} and select the target channel.
4. Credential Required: Connect your slackApi credentials for Slack Success Alert.
5. Configure Email Success Notice with the HTML body content using {{ $('Map Post Fields').item.json.caption }}, {{ $('Map Post Fields').item.json.image_url }}, and {{ $json.id }}.
6. Credential Required: Connect your microsoftOutlookOAuth2Api credentials for Email Success Notice.
7. On the failure branch, configure Slack Failure Alert text to include {{ $json.error.message || $json.message || 'Unknown error' }} and pick a channel.
8. Credential Required: Connect your slackOAuth2Api credentials for Slack Failure Alert.
9. Set Email Failure Notice subject to ❌ Meta Post Failed.
10. Credential Required: Connect your smtp credentials for Email Failure Notice.

Step 6: Test and Activate Your Workflow

Verify the end-to-end flow before running in production.

1. Click Execute Workflow and ensure Pending Sheet Poller captures sample rows.
2. Confirm Select Latest Pending Row returns the latest row with status set to pending.
3. Check that Publish to Meta API returns a valid ID and Validate Publish Result routes correctly.
4. On success, verify both Slack Success Alert and Email Success Notice fire, and the sheet updates in Mark Sheet Row Completed.
5. On failure, verify Slack Failure Alert and Email Failure Notice trigger with the error message.
6. When everything works, toggle the workflow to Active for production use.