Automatically create WordPress posts from Google Sheets data using ChatGPT and Markdown.
Streamline content creation with this powerful integration.
Automatically create WordPress posts from Google Sheets data using ChatGPT and Markdown.
Streamline content creation with this powerful integration.
{
"name": "Create WordPress posts from Google Sheets data using ChatGPT and Markdown compilation",
"flow": [
{
"id": 1,
"module": "google-sheets:watchRows",
"version": 2,
"parameters": {
"from": "drive",
"mode": "select",
"limit": 2,
"sheetId": "Sheet1",
"spreadsheetId": "/1OBN2px7hcLH4AEaw2p08dU5g3Ti_prtpzSLfLgpa3XQ",
"tableFirstRow": "A1:Z1",
"includesHeaders": true,
"valueRenderOption": "FORMATTED_VALUE",
"dateTimeRenderOption": "FORMATTED_STRING"
},
"mapper": {},
"metadata": {
"designer": {
"x": 300,
"y": 0
},
"restore": {
"parameters": {
"from": {
"label": "My Drive"
},
"mode": {
"label": "Search by path"
},
"sheetId": {
"label": "Sheet1"
},
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (l.govender@make.com)"
},
"spreadsheetId": {
"path": [
"App partner templates (last template reviewed)"
]
},
"includesHeaders": {
"label": "Yes"
},
"valueRenderOption": {
"mode": "chose",
"label": "Formatted value"
},
"dateTimeRenderOption": {
"mode": "chose",
"label": "Formatted string"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection",
"required": true
},
{
"name": "mode",
"type": "select",
"label": "Search Method",
"required": true,
"validate": {
"enum": [
"select",
"fromAll",
"map"
]
}
},
{
"name": "includesHeaders",
"type": "select",
"label": "Table contains headers",
"required": true,
"validate": {
"enum": [
true,
false
]
}
},
{
"name": "limit",
"type": "uinteger",
"label": "Limit",
"required": true
},
{
"name": "valueRenderOption",
"type": "select",
"label": "Value render option",
"validate": {
"enum": [
"FORMATTED_VALUE",
"UNFORMATTED_VALUE",
"FORMULA"
]
}
},
{
"name": "dateTimeRenderOption",
"type": "select",
"label": "Date and time render option",
"validate": {
"enum": [
"SERIAL_NUMBER",
"FORMATTED_STRING"
]
}
},
{
"name": "from",
"type": "select",
"label": "Drive",
"required": true,
"validate": {
"enum": [
"drive",
"share",
"team"
]
}
},
{
"name": "spreadsheetId",
"type": "file",
"label": "Spreadsheet ID",
"required": true
},
{
"name": "sheetId",
"type": "select",
"label": "Sheet Name",
"required": true
},
{
"name": "tableFirstRow",
"type": "text",
"label": "Row with headers",
"required": true
}
],
"interface": [
{
"name": "__ROW_NUMBER__",
"type": "number",
"label": "Row number"
},
{
"name": "__SPREADSHEET_ID__",
"type": "text",
"label": "Spreadsheet ID"
},
{
"name": "__SHEET__",
"type": "text",
"label": "Sheet"
},
{
"name": "0",
"type": "text",
"label": "Date (A)"
},
{
"name": "1",
"type": "text",
"label": "Zone EU1 (B)"
},
{
"name": "2",
"type": "text",
"label": "Zone US1 (C)"
},
{
"name": "3",
"type": "text",
"label": "Zone Celonis ent EU1 (D)"
},
{
"name": "4",
"type": "text",
"label": "Zone Celonis ent US1 (E)"
},
{
"name": "5",
"type": "text",
"label": "Zone makerunsmake (F)"
},
{
"name": "6",
"type": "text",
"label": "Zone EU2 (G)"
},
{
"name": "7",
"type": "text",
"label": "Zone US2 (H)"
},
{
"name": "8",
"type": "text",
"label": "Monday board (I)"
},
{
"name": "9",
"type": "text",
"label": "(J)"
},
{
"name": "10",
"type": "text",
"label": "(K)"
},
{
"name": "11",
"type": "text",
"label": "(L)"
},
{
"name": "12",
"type": "text",
"label": "(M)"
},
{
"name": "13",
"type": "text",
"label": "(N)"
},
{
"name": "14",
"type": "text",
"label": "(O)"
},
{
"name": "15",
"type": "text",
"label": "(P)"
},
{
"name": "16",
"type": "text",
"label": "(Q)"
},
{
"name": "17",
"type": "text",
"label": "(R)"
},
{
"name": "18",
"type": "text",
"label": "(S)"
},
{
"name": "19",
"type": "text",
"label": "(T)"
},
{
"name": "20",
"type": "text",
"label": "(U)"
},
{
"name": "21",
"type": "text",
"label": "(V)"
},
{
"name": "22",
"type": "text",
"label": "(W)"
},
{
"name": "23",
"type": "text",
"label": "(X)"
},
{
"name": "24",
"type": "text",
"label": "(Y)"
},
{
"name": "25",
"type": "text",
"label": "(Z)"
}
]
}
},
{
"id": 2,
"module": "openai-gpt-3:CreateCompletion",
"version": 1,
"parameters": {},
"mapper": {
"model": "o3-mini-2025-01-31",
"top_p": "1",
"select": "chat",
"messages": [
{
"role": "user"
}
],
"max_tokens": "2048",
"temperature": "1",
"n_completions": "1",
"response_format": "text"
},
"metadata": {
"designer": {
"x": 600,
"y": 0
},
"restore": {
"expect": {
"stop": {
"mode": "chose"
},
"model": {
"mode": "chose",
"label": "o3-mini-2025-01-31 (system)"
},
"select": {
"label": "Create a Chat Completion (GPT and o1 models)"
},
"messages": {
"mode": "chose",
"items": [
{
"role": {
"mode": "chose",
"label": "User"
}
}
]
},
"logit_bias": {
"mode": "chose"
},
"response_format": {
"mode": "chose",
"label": "Text"
},
"reasoning_effort": {
"mode": "chose",
"label": "Empty"
},
"additionalParameters": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "openai-gpt-3"
},
"label": "Make Ent GPT4"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:openai-gpt-3",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "select",
"type": "select",
"label": "Select Method",
"required": true,
"validate": {
"enum": [
"chat",
"prompt"
]
}
},
{
"name": "temperature",
"type": "number",
"label": "Temperature",
"validate": {
"max": 2,
"min": 0
}
},
{
"name": "top_p",
"type": "number",
"label": "Top P",
"validate": {
"max": 1,
"min": 0
}
},
{
"name": "n_completions",
"type": "number",
"label": "Number"
},
{
"name": "frequency_penalty",
"type": "number",
"label": "Frequency Penalty",
"validate": {
"max": 2,
"min": -2
}
},
{
"name": "presence_penalty",
"type": "number",
"label": "Presence Penalty",
"validate": {
"max": 2,
"min": -2
}
},
{
"name": "logit_bias",
"spec": {
"name": "value",
"spec": [
{
"name": "token",
"type": "text",
"label": "Token ID",
"required": true
},
{
"name": "probability",
"type": "number",
"label": "Probability",
"required": true,
"validate": {
"max": 100,
"min": -100
}
}
],
"type": "collection",
"label": "Token Probability"
},
"type": "array",
"label": "Token Probability"
},
{
"name": "seed",
"type": "integer",
"label": "Seed"
},
{
"name": "stop",
"spec": {
"name": "value",
"type": "text",
"label": "Stop Sequence"
},
"type": "array",
"label": "Stop Sequences",
"validate": {
"maxItems": 4
}
},
{
"name": "additionalParameters",
"spec": {
"name": "value",
"spec": [
{
"name": "key",
"type": "text",
"label": "Parameter Name",
"required": true
},
{
"name": "type",
"type": "select",
"label": "Input Type",
"options": [
{
"label": "Text",
"value": "text",
"nested": [
{
"name": "value",
"type": "text",
"label": "Parameter Value"
}
],
"default": true
},
{
"label": "Number",
"value": "number",
"nested": [
{
"name": "value",
"type": "number",
"label": "Parameter Value"
}
]
},
{
"label": "Boolean",
"value": "boolean",
"nested": [
{
"name": "value",
"type": "boolean",
"label": "Parameter Value"
}
]
},
{
"label": "Date",
"value": "date",
"nested": [
{
"name": "value",
"type": "date",
"label": "Parameter Value"
}
]
},
{
"label": "Any",
"value": "any",
"nested": [
{
"name": "value",
"type": "any",
"label": "Parameter Value"
}
]
}
]
}
],
"type": "collection",
"label": "Input Parameter"
},
"type": "array",
"label": "Other Input Parameters"
},
{
"name": "model",
"type": "select",
"label": "Model",
"required": true
},
{
"name": "max_tokens",
"type": "uinteger",
"label": "Max Completion Tokens"
},
{
"name": "messages",
"spec": {
"name": "value",
"spec": [
{
"name": "role",
"type": "select",
"label": "Role",
"options": {
"store": [
{
"label": "User",
"value": "user",
"nested": [
{
"help": "Text content of the message on behalf of the selected __Role__.",
"name": "content",
"type": "text",
"label": "Text Content"
}
]
},
{
"label": "Assistant",
"value": "assistant",
"nested": [
{
"help": "Text content of the message on behalf of the selected __Role__.",
"name": "content",
"type": "text",
"label": "Text Content"
}
]
},
{
"label": "Developer / System",
"value": "system",
"nested": [
{
"help": "Text content of the message on behalf of the selected __Role__.",
"name": "content",
"type": "text",
"label": "Text Content"
}
]
}
]
},
"required": true
}
],
"type": "collection",
"label": "Message"
},
"type": "array",
"label": "Messages",
"required": true
},
{
"name": "response_format",
"type": "select",
"label": "Response Format",
"validate": {
"enum": [
"text",
"json_object"
]
}
},
{
"name": "reasoning_effort",
"type": "select",
"label": "Reasoning Effort",
"validate": {
"enum": [
"low",
"medium",
"high"
]
}
}
],
"interface": [
{
"name": "result",
"type": "any",
"label": "Result"
},
{
"name": "id",
"type": "text",
"label": "ID"
},
{
"name": "object",
"type": "text",
"label": "Object"
},
{
"name": "created",
"type": "date",
"label": "Created"
},
{
"name": "model",
"type": "text",
"label": "Model"
},
{
"name": "choices",
"spec": {
"spec": [
{
"name": "text",
"type": "text",
"label": "Text"
},
{
"name": "index",
"type": "number",
"label": "Index"
},
{
"name": "logprobs",
"type": "text",
"label": "Log Probs"
},
{
"name": "finish_reason",
"type": "text",
"label": "Finish Reason"
},
{
"name": "message",
"spec": [
{
"name": "role",
"type": "text",
"label": "Role"
},
{
"name": "content",
"type": "text",
"label": "Content"
},
{
"name": "refusal",
"type": "text",
"label": "Refusal"
}
],
"type": "collection",
"label": "Message"
}
],
"type": "collection"
},
"type": "array",
"label": "Choices"
},
{
"name": "usage",
"spec": [
{
"name": "prompt_tokens",
"type": "number",
"label": "Prompt Tokens"
},
{
"name": "completion_tokens",
"type": "text",
"label": "Completion Tokens"
},
{
"name": "total_tokens",
"type": "number",
"label": "Total Tokens"
},
{
"name": "prompt_tokens_details",
"spec": [
{
"name": "cached_tokens",
"type": "uinteger",
"label": "Cached Tokens"
},
{
"name": "text_tokens",
"type": "uinteger",
"label": "Text Tokens"
},
{
"name": "image_tokens",
"type": "uinteger",
"label": "Image Tokens"
},
{
"name": "audio_tokens",
"type": "uinteger",
"label": "Audio Tokens"
}
],
"type": "collection",
"label": "Prompt Tokens Details"
},
{
"name": "completion_tokens_details",
"spec": [
{
"name": "reasoning_tokens",
"type": "uinteger",
"label": "Reasoning Tokens"
},
{
"name": "text_tokens",
"type": "uinteger",
"label": "Text Tokens"
},
{
"name": "audio_tokens",
"type": "uinteger",
"label": "Audio Tokens"
},
{
"name": "accepted_prediction_tokens",
"type": "uinteger",
"label": "Accepted Prediction Tokens"
},
{
"name": "rejected_prediction_tokens",
"type": "uinteger",
"label": "Rejected Prediction Tokens"
}
],
"type": "collection",
"label": "Completion Tokens Details"
}
],
"type": "collection",
"label": "Usage"
},
{
"name": "service_tier",
"type": "text",
"label": "Service Tier"
},
{
"name": "system_fingerprint",
"type": "text",
"label": "System Fingerprint"
}
]
}
},
{
"id": 3,
"module": "markdown:Compile",
"version": 2,
"parameters": {},
"mapper": {
"gfm": true,
"data": "{{2.result}}",
"sanitize": false
},
"metadata": {
"designer": {
"x": 900,
"y": 0
},
"restore": {
"expect": {
"gfm": {
"mode": "chose"
},
"sanitize": {
"mode": "chose"
}
}
},
"expect": [
{
"name": "data",
"type": "text",
"label": "Markdown"
},
{
"name": "gfm",
"type": "boolean",
"label": "GitHub Flavored Markdown",
"required": true
},
{
"name": "sanitize",
"type": "boolean",
"label": "Sanitize",
"required": true
}
]
}
},
{
"id": 4,
"module": "wordpress:createPost",
"version": 3,
"parameters": {},
"mapper": {
"date": "{{1.`4`}}",
"slug": "{{1.`2`}}",
"type": "posts",
"title": "{{1.`0`}}",
"content": "{{3.data}}"
},
"metadata": {
"designer": {
"x": 1200,
"y": 0
},
"restore": {
"expect": {
"meta": {
"mode": "chose"
},
"tags": {
"mode": "chose"
},
"type": {
"mode": "chose",
"label": "Posts"
},
"author": {
"mode": "chose",
"label": "Empty"
},
"format": {
"mode": "chose",
"label": "Empty"
},
"status": {
"mode": "chose",
"label": "Empty"
},
"sticky": {
"mode": "chose"
},
"taxonomy": {
"mode": "chose"
},
"categories": {
"mode": "chose"
},
"pingStatus": {
"mode": "chose",
"label": "Empty"
},
"commentStatus": {
"mode": "chose",
"label": "Empty"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "wordpress4"
},
"label": "My WordPress connection (thanos)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:wordpress4",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "title",
"type": "text",
"label": "Title",
"required": true
},
{
"name": "content",
"type": "text",
"label": "Content",
"required": true
},
{
"name": "type",
"type": "select",
"label": "Type",
"required": true
},
{
"name": "excerpt",
"type": "text",
"label": "Excerpt"
},
{
"name": "date",
"type": "date",
"label": "Date"
},
{
"name": "slug",
"type": "text",
"label": "Slug"
},
{
"name": "status",
"type": "select",
"label": "Status"
},
{
"name": "format",
"type": "select",
"label": "Format"
},
{
"name": "parent",
"type": "number",
"label": "Parent object ID"
},
{
"name": "categories",
"type": "select",
"label": "Categories",
"multiple": true
},
{
"name": "tags",
"type": "select",
"label": "Tags",
"multiple": true
},
{
"name": "author",
"type": "select",
"label": "Author"
},
{
"name": "featuredMedia",
"type": "number",
"label": "Featured media ID"
},
{
"name": "template",
"type": "text",
"label": "Template"
},
{
"name": "password",
"type": "text",
"label": "Password"
},
{
"name": "sticky",
"type": "boolean",
"label": "Sticky"
},
{
"name": "commentStatus",
"type": "select",
"label": "Comment status",
"validate": {
"enum": [
"open",
"closed"
]
}
},
{
"name": "pingStatus",
"type": "select",
"label": "Ping status",
"validate": {
"enum": [
"open",
"closed"
]
}
},
{
"name": "taxonomy",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "values",
"type": "array",
"label": "Values",
"required": true
}
],
"type": "array",
"label": "Additional fields"
},
{
"name": "meta",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value"
}
],
"type": "array",
"label": "Metadata (custom fields)"
}
],
"advanced": true
}
}
],
"metadata": {
"instant": false,
"version": 1,
"scenario": {
"roundtrips": 1,
"maxErrors": 3,
"autoCommit": true,
"autoCommitTriggerLast": true,
"sequential": false,
"slots": null,
"confidential": false,
"dataloss": false,
"dlq": false,
"freshVariables": false
},
"designer": {
"orphans": []
},
"zone": "eu2.make.com",
"notes": []
}
}