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:
- Find the first approved row that has no job IDs.
- Check the row, then mark it as sending.
- Upload one image and ask Mallary to post it on all three sites.
- Save the job IDs and mark the row as submitted.
- 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
- Create a Mallary account, or sign in.
- Open Platforms and connect your Facebook Page, Instagram account, and LinkedIn person or company Page.
- 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.
- Create a Header Auth credential in n8n. A credential is where n8n stores a secret.
- Set its Name field to
Authorization. - Set its Value to
Bearer YOUR_API_KEY. ReplaceYOUR_API_KEYwith your key. Keep the space afterBearer. - 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.
| Column | What goes here |
|---|---|
content_id | A unique name for this post, such as coffee-001. Never use the same ID for two rows. |
caption | The words for all three sites. Use 2,200 characters or fewer. |
image_url | A direct HTTPS link to a square JPG, 8 MB or less. Try 1080 by 1080 pixels. |
status | Start with draft. Change it to approved after you review the row. |
job_ids | Leave blank. The sender saves each site's job ID here. |
post_urls | Leave blank. The checker adds live links when available. |
platform_status | Leave blank. The checker saves each site's status here. |
error | Leave 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/. 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
- Create a new workflow in n8n.
- Open the top-right menu and choose Import from File. Select the send workflow file.
- Keep automatic runs off while you set it up.
- Open Sheet settings. Set
spreadsheet_idto the part of your sheet's URL between/d/and/edit. Setsheet_nameto your tab name, such asPosts. - Choose your Google Sheets credential in every Google Sheets node.
- Choose your Mallary Header Auth credential in Get Mallary upload URL and Create social posts.
- 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.
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
- Check the caption, image, and all three accounts.
- Make sure the row has a unique
content_idand an emptyjob_idscell. - Change only that row's status to
approved. Keep your other rows as drafts. - 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.
livemeans all posts were published.partialmeans some posts went live and others failed or need action.failedmeans all posts failed or need action.submittedmeans 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.