Hello! I’m having problems automating a Twitter account, my idea is retrieving the videos from google drive along a caption from excel, I tested it and it works right for images but as soon as I try to make it work with videos I get an error on the HTTP request. There’s anything I need to modify to make it work?
Adding the workflow and HTTP data below.
Thanks for your time!
Hello @Amber_Suave - what is the http error - can you share a screenshot of the error. or upload te canvas and I’ll give it a try on my side.
"name": "My workflow",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 8
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
-768,
64
],
"id": "72dcae0c-d360-4dd6-88f7-1be583e958b3",
"name": "Schedule Trigger"
},
{
"parameters": {
"text": "={{ $('Get row(s) in sheet').item.json.Quote }}",
"additionalFields": {
"attachments": "={{ $json.media_id_string}}"
}
},
"type": "n8n-nodes-base.twitter",
"typeVersion": 2,
"position": [
80,
-96
],
"id": "ec412975-9f39-48cb-8e8b-3c91bbe92800",
"name": "Create Tweet",
"credentials": {
"twitterOAuth2Api": {
"id": "pgrm8hwZIWKlQP34",
"name": "X account 2"
}
}
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1QbQBHEhR5YJQoC7NULhj6WDTM7WFIgn2YpbLYzaMgUI",
"mode": "list",
"cachedResultName": "Autotweet",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1QbQBHEhR5YJQoC7NULhj6WDTM7WFIgn2YpbLYzaMgUI/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1QbQBHEhR5YJQoC7NULhj6WDTM7WFIgn2YpbLYzaMgUI/edit#gid=0"
},
"filtersUI": {
"values": [
{
"lookupColumn": "Status",
"lookupValue": "pendent"
}
]
},
"options": {
"returnFirstMatch": true
}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
-560,
64
],
"id": "3c3d073a-dc4c-4381-900a-87d1acb979f3",
"name": "Get row(s) in sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "rKDOrnpDUgN3FKka",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"operation": "download",
"fileId": {
"__rl": true,
"value": "1gxmeHOtSmDCAhz5gjAG9hh7uDSZ9gKV4",
"mode": "list",
"cachedResultName": "754df670847669f07c44eccfa6975f10.mp4",
"cachedResultUrl": "https://drive.google.com/file/d/1gxmeHOtSmDCAhz5gjAG9hh7uDSZ9gKV4/view?usp=drivesdk"
},
"options": {
"binaryPropertyName": "data"
}
},
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
-304,
-96
],
"id": "23dde9b2-bec4-4f4a-b0ac-a1982a922585",
"name": "Download file",
"credentials": {
"googleDriveOAuth2Api": {
"id": "YmdvwxwDys0rHJr6",
"name": "Google Drive account"
}
}
},
{
"parameters": {
"method": "POST",
"url": "https://upload.twitter.com/1.1/media/upload.json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "twitterOAuth1Api",
"sendBody": true,
"contentType": "multipart-form-data",
"bodyParameters": {
"parameters": [
{
"name": "media_category",
"value": "tweet_image"
},
{
"parameterType": "formBinaryData",
"name": "media",
"inputDataFieldName": "data"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.3,
"position": [
-96,
-96
],
"id": "656b7000-b250-4ff7-8fe7-57de58da1f52",
"name": "HTTP Request",
"credentials": {
"twitterOAuth2Api": {
"id": "pgrm8hwZIWKlQP34",
"name": "X account 2"
},
"twitterOAuth1Api": {
"id": "X9yBOjaiANZwFQRI",
"name": "X OAuth account"
},
"oAuth2Api": {
"id": "061tuf1v4Yy44XLc",
"name": "Unnamed credential 2"
}
}
}
],
"pinData": {},
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Create Tweet": {
"main": [
[]
]
},
"Download file": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Download file",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Create Tweet",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "09c7d16a-efcf-4cea-b700-788b9d7c5971",
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "24374070a3dd96b2380c07c81dfc9eb2e55c78366ddef12143ccdb5259eeab6c"
},
"id": "bkKUf7CAp8SELGoq",
"tags": []
}