A step-by-step guide

How to automate social media posting with n8n and Mallary

Post one caption and image to Facebook, Instagram, and LinkedIn with n8n and Mallary. Use n8n Cloud or self-hosted n8n, with workflows you can download.

Write one caption and choose one photo. With n8n and Mallary, you can send that same content to Facebook, Instagram, and LinkedIn from a Google Sheet.

Use n8n Cloud or self-hosted n8n. One workflow sends approved posts. A second workflow checks each site's result.

Before you start

You will need:

  • A Mallary account with an active plan or trial. Compare Mallary plans.
  • An n8n Cloud or self-hosted n8n account. The downloads use built-in nodes.
  • A Google account with access to Google Sheets.
  • A Facebook Page, an Instagram business or creator account, and a LinkedIn account. Connect them in Mallary.
  • One square JPG at a public, direct HTTPS link. The link must open the image itself.

A workflow runs a set of steps. Here is the flow:

  1. Find the first approved row that has no job IDs.
  2. Check the row, then mark it as sending.
  3. Upload one image and ask Mallary to post it on all three sites.
  4. Save the job IDs and mark the row as submitted.
  5. Use the second workflow to check each site and save its result.

Automatic runs start turned off. A manual run can still create real posts. Check your accounts and content before you run the sender.

Step 01 / Choose your accounts

Set up Mallary

  1. Create a Mallary account, or sign in.
  2. Open Platforms and connect your Facebook Page, Instagram account, and LinkedIn person or company Page.
  3. Check each account name. Start with one account per site for this example.

Facebook needs a Page. Personal Facebook accounts cannot be used for this workflow.

Get your API key from the Mallary dashboard. Keep it in n8n credentials. Do not put it in the sheet or a workflow download.

Step 02 / Connect n8n

Add your Mallary key to n8n

The built-in HTTP Request node lets n8n talk to Mallary. No extra node install is needed.

  1. Create a Header Auth credential in n8n. A credential is where n8n stores a secret.
  2. Set its Name field to Authorization.
  3. Set its Value to Bearer YOUR_API_KEY. Replace YOUR_API_KEY with your key. Keep the space after Bearer.
  4. Give the credential a name you will know, such as Mallary, and save it.

Step 03 / Build your post list

Prepare your Google Sheet

Download the sample sheet as a CSV file. Import it into Google Sheets. Keep the column names exactly as shown.

Fill in the first four columns. Leave the other columns blank; the workflows fill them in for you. Keep the row as a draft during setup.

Set the content_id and job_ids columns to Format > Number > Plain text before you enter values.

Start by posting now. You do not need to enter a date or time zone.

ColumnWhat goes here
content_idA unique name for this post, such as coffee-001. Never use the same ID for two rows.
captionThe words for all three sites. Use 2,200 characters or fewer.
image_urlA direct HTTPS link to a square JPG, 8 MB or less. Try 1080 by 1080 pixels.
statusStart with draft. Change it to approved after you review the row.
job_idsLeave blank. The sender saves each site's job ID here.
post_urlsLeave blank. The checker adds live links when available.
platform_statusLeave blank. The checker saves each site's status here.
errorLeave blank. The checker adds errors with the site names.

For example, use one latte photo with this caption: “Our new iced vanilla latte is here. Stop by for a coffee break.” The workflow sends both to all three sites.

Give each new post a new content_id. The workflow uses it to save results to the right row. Do not change it after sending.

Optional: choose a time to post later

Skip this for your first post. The sample sheet is set up to post when you run the sender.

To post later, add two columns: scheduled_at and time_zone. Set scheduled_at to Plain text. Enter a future time such as 2026-12-01T09:00:00 and a time zone such as America/New_York. Choose your own date at least five minutes ahead.

The time zone tells Mallary what “9 a.m.” means. It is only needed when you enter a local date and time. Leave both cells blank to post now.

Step 04 / Add your workflows

Import and connect both workflows

  1. Create a new workflow in n8n.
  2. Open the top-right menu and choose Import from File. Select the send workflow file.
  3. Keep automatic runs off while you set it up.
  4. Open Sheet settings. Set spreadsheet_id to the part of your sheet's URL between /d/ and /edit. Set sheet_name to your tab name, such as Posts.
  5. Choose your Google Sheets credential in every Google Sheets node.
  6. Choose your Mallary Header Auth credential in Get Mallary upload URL and Create social posts.
  7. Save the sender. Import the status file into a second workflow.

In the status workflow, set both fields in Sheet settings. Choose your Google credential in both Sheets nodes. Choose your Mallary Header Auth credential in Get Mallary job.

Use the same sheet for both workflows. Your Google credential needs access to edit it.

Leave Download image and Upload image to storage without a Mallary credential. The key belongs only on requests to Mallary's API.

The sender marks the row sending, uploads the image, and creates posts for the three sites. It saves all job IDs and sets status to submitted.

Run one at a time.

Do not start two runs for this sheet at once. Two runs could read the same row before either marks it as sending.

Step 05 / Send one piece of content

Send your first row to three sites

  1. Check the caption, image, and all three accounts.
  2. Make sure the row has a unique content_id and an empty job_ids cell.
  3. Change only that row's status to approved. Keep your other rows as drafts.
  4. Run the send workflow once. Wait for it to finish.

This run sends real posts. It is not a preview.

The sender takes one approved row per run. It sends that row to all three sites in one request.

Look for submitted and a list in job_ids. Leave that list as the workflow wrote it. Job IDs show that Mallary accepted the work. They do not prove the posts are live.

Step 06 / Check the result

Run the status workflow

Run the second workflow after the sender finishes. It checks all submitted rows that have job IDs. It does not create posts.

  • live means all posts were published.
  • partial means some posts went live and others failed or need action.
  • failed means all posts failed or need action.
  • submitted means a job is still waiting, or its status could not be read. Check the error, then run the checker again.

Read platform_status for each site's result. Open the links in post_urls to check the live posts. A scheduled post waits until its time arrives.

If only one site fails, do not resend the whole row. Check the failed post in Posts in Mallary. Leave the posts that went live alone.

Step 07 / Repeat the steps

Optional: run on a schedule

You can keep running the workflows by hand. Skip this step while you learn the flow.

Set up automatic runs later

Once both manual runs work, replace Run manually with a Schedule Trigger in each workflow. Connect it to Sheet settings. One workflow sends approved rows. The other checks submitted jobs.

These workflows do not lock the sheet. Keep the sender manual unless your n8n setup can block runs from overlapping. A long gap between runs is not a lock.

For self-hosted n8n on one server in regular mode, an admin can set N8N_CONCURRENCY_PRODUCTION_LIMIT=1. This makes automatic runs wait. It affects all automatic workflows on that server. See n8n's guide to run limits.

That limit does not cover runs started by hand. Turn off schedules and wait for active runs to end before a manual test. Do not run another sender for this sheet elsewhere.

Check the trigger times and n8n's time zone. Use Publish or Activate to turn on runs once your setup is ready. Keep new rows as drafts until they are checked.

Fix common problems

n8n cannot connect to Mallary

Check the Header Auth credential. Its header name must be Authorization. The value must start with Bearer, followed by a space and your key. Use it only on the Mallary API nodes.

The wrong account is selected

Check the connected account names in Platforms. For this example, start with one account for each site.

The image will not upload

Open the image link in a private browser window. It must show your square JPG without a sign-in. A Google Drive share page is not a direct image link.

The scheduled time is wrong

Check the date format and full time zone name. Then check the saved time in Posts. Fix the existing scheduled post there. Do not send a new copy to change its time.

A row is stuck on sending

Check the n8n run and your recent Mallary posts. The post may exist even if the sheet update failed. Do not change the row back to approved or run it again until you know what happened.

The post is still submitted

Check its scheduled time and job status. Run the checker later. Running the sender again will not make an existing job finish sooner.

One site failed but others worked

Read that site's error. Fix the cause, then check its existing post before you retry. Do not clear job_ids or approve the whole row again. That could repeat posts that already went live.

Need help? Share the job ID and error with Mallary support. Keep your API key private.

Quick answers

Can one n8n workflow post to several sites?

Yes. These downloads send one caption and one image to Facebook, Instagram, and LinkedIn. The checker tracks each site's result.

Does this work on n8n Cloud?

Yes. The workflows use built-in nodes. You do not need the Mallary community package. Set up your credentials and sheet before you run them.

Can I choose other sites?

This starter workflow is set to Facebook, Instagram, and LinkedIn. For other sites, change the chosen platform list, the post request, and the checks. Test that version before you use it.

Start with one row

Build a post list you can trust

Write one caption and pick one photo. Send them to your three accounts. Check each result, then add more drafts to your sheet.

See the Mallary n8n integration, read the Mallary API docs, or browse all guides.