Step 2: Connect Google Sheets

Pull queued posts from your sheet and write back status updates after posting.

1. Open Retrieve Sheet Rows and choose your Document and Sheet from the list.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Sheet Rows.
3. Open Write Back to Sheet and select the same Document and Sheet.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials in Write Back to Sheet.
5. Verify the update mapping in Write Back to Sheet: set Status to Posted, Post Link to {{ $json.postLink }}, Posted At to {{ $now.setZone($('Setup Defaults').first().json.timezone || 'UTC').toFormat('yyyy-MM-dd HH:mm') }}, and match on row_number with {{ $('Iterate Batch Items').item.json.row_number }}.

Step 3: Set Up Defaults and BlueSky Authentication

Provide account settings and authenticate to BlueSky before posting.

1. In Setup Defaults, set bluesky_handle and app_password to your BlueSky credentials (currently empty), and confirm timezone is Asia/Kolkata (or adjust to your local timezone).
2. In BlueSky Session Login, confirm the URL is https://bsky.social/xrpc/com.atproto.server.createSession and Method is POST.
3. Set the JSON Body to { "identifier":"{{$('Setup Defaults').first().json.bluesky_handle}}", "password": "{{ $('Setup Defaults').first().json.app_password }}" }.
4. Connect Setup Defaults → BlueSky Session Login → Retrieve Sheet Rows.

Step 4: Filter, Sort, and Batch Sheet Rows

Only rows ready to post should be processed, then sorted for threading and batched for sequential posting.

1. In Filter Ready Records, confirm conditions:
   Status equals Ready, Scheduled Time is not empty, and Scheduled Time is before or equal to {{ $now.setZone($('Setup Defaults').first().json.timezone) }} using {{ DateTime.fromFormat($json['Scheduled Time'], 'yyyy-MM-dd HH:mm', { zone: $('Setup Defaults').first().json.timezone }) }}.
2. In Order Thread Items, set sort fields to Thread ID then Sequence to preserve thread order.
3. Use Iterate Batch Items to process records in batches (default options are fine for sequential processing).

Step 5: Set Up Image Handling and Data Merge

Handle optional image uploads and merge image data into the posting stream.

1. In Image Presence Check, keep the condition that checks {{ $json["Image URL"] }} is not empty.
2. Image Presence Check outputs to both Fetch Image File and Merge Image Blob in parallel.
3. In Fetch Image File, set URL to {{ $json["Image URL"] }}.
4. In Upload Media Blob, confirm URL is https://bsky.social/xrpc/com.atproto.repo.uploadBlob, Method is POST, and headers include Authorization Bearer {{ $('BlueSky Session Login').first().json.accessJwt }} and Content-Type {{ $binary.data.mimeType }}.
5. In Merge Image Blob, set Mode to combine and Combine By to combineByPosition.
6. Connect Merge Image Blob → Unify Streams to combine image and non-image items.

Step 6: Build and Submit the BlueSky Post

Transform each row into a BlueSky post payload and submit it to the API.

1. In Build Post Payload, keep the provided JavaScript that builds the record, handles images via json.blob, and manages threading via workflow static data.
2. Connect Unify Streams → Build Post Payload → Submit Post Request.
3. In Submit Post Request, set URL to https://bsky.social/xrpc/com.atproto.repo.createRecord, Method to POST, and JSON Body to {{ $node["Build Post Payload"].data }}.
4. Ensure the Authorization header uses Bearer {{ $('BlueSky Session Login').first().json.accessJwt }}.

Step 7: Update Sheet with Posting Results

Capture the BlueSky post URI and link, then write back to the sheet and continue batching.

1. In Refresh Thread State, keep the JavaScript that builds postLink and preserves thread state across items.
2. Connect Submit Post Request → Refresh Thread State → Write Back to Sheet.
3. Connect Write Back to Sheet back to Iterate Batch Items to continue posting until all items are processed.

Step 8: Test and Activate Your Workflow

Run a manual test to confirm successful posting and sheet updates, then enable the schedule.

1. Click Execute Workflow to run a manual test with a few rows marked Ready and valid Scheduled Time.
2. Confirm a post is created in BlueSky and that Write Back to Sheet updates Status to Posted with Post Link and Posted At.
3. If images are included, verify that Fetch Image File → Upload Media Blob completes and the post includes the image.
4. Toggle the workflow to Active so Scheduled Run Trigger runs every 15 minutes in production.