Google Sheet not updated
-
I am working on adding a feature such that any blog post published is also added to Google Sheets. Not sure where I am going wrong. Maybe I have not connected the heading of the columns in Google Sheets with Automator appropriately.
Help appreciated. Thanks!
-
This topic was modified 3 months ago by
Digital Splendid.
The page I need help with: [log in to see the link]
-
This topic was modified 3 months ago by
-
Hi @rajeevbagra2025,
Thank you for sharing the screenshots. On the Google sheet action, where it says “completed with errors”, could you expand this section by clicking the
>icon and share a screenshot of the details that appear on the right of the UI.Better still, could you download and share that specific log file? You can upload the
.jsonfile and share a link or simply copy and paste the contents in a reply here. Else, you could reach out to [email protected] with the.jsonfile attached.The error details should help us identify what the issue is and help get it fixed, asap.
Best
{
"recipe_id": 5135,
"run_number": 1,
"title": "new blog publish",
"status_id": "completed-with-errors",
"start_date": "December 27, 2024 5:13 pm",
"end_date": "December 27, 2024 5:13 pm",
"date_elapsed": {
"elapsed_in_seconds": 0,
"human_time_diff": "1 second"
},
"triggered_by_user": 1,
"triggers": {
"logic": "ALL",
"items": [
{
"type": "trigger",
"id": 5136,
"integration_code": "WP",
"is_deleted": false,
"status_id": "completed",
"start_date": "December 27, 2024 5:13 pm",
"end_date": "December 27, 2024 5:13 pm",
"date_elapsed": {
"elapsed_in_seconds": 0,
"human_time_diff": "1 second"
},
"code": "WP_USER_POST_PUBLISHED",
"title_html": "<div><span class="item-title__normal">A user publishes a </span><span class="item-title__token" data-token-id="WPPOSTTYPES" data-options-id="WPPOSTTYPES"><span class="item-title__token-label">Post type:</span> Any post type</span></div>",
"fields": [
{
"field_code": "WPPOSTTYPES",
"type": "select",
"label": "Post type",
"attributes": [],
"value": {
"readable": "Any post type",
"raw": "-1"
}
}
],
"runs": [
{
"date": "December 27, 2024 5:13 pm",
"used_credit": false,
"status_id": "completed",
"properties": [
{
"type": "code",
"label": "Trigger backtrace (for support)",
"value": "array (\n 0 => 'require(\\'wp-blog-header.php\\'),',\n 1 => 'wp,',\n 2 => 'WP->main,',\n 3 => 'WP->parse_request,',\n 4 => 'do_action_ref_array(\\'parse_request\\'),',\n 5 => 'WP_Hook->do_action,',\n 6 => 'WP_Hook->apply_filters,',\n 7 => 'rest_api_loaded,',\n 8 => 'WP_REST_Server->serve_request,',\n 9 => 'WP_REST_Server->dispatch,',\n 10 => 'WP_REST_Server->respond_to_request,',\n 11 => 'WP_REST_Posts_Controller->update_item,',\n 12 => 'wp_after_insert_post,',\n 13 => 'do_action(\\'wp_after_insert_post\\'),',\n 14 => 'WP_Hook->do_action,',\n 15 => 'WP_Hook->apply_filters,',\n 16 => 'Uncanny_Automator\\\\WP_USERS_POST_PUBLISHED->validate,',\n 17 => 'Uncanny_Automator\\\\WP_USERS_POST_PUBLISHED->process_trigger,',\n 18 => 'Uncanny_Automator\\\\Automator_Recipe_Process_User->maybe_trigger_complete,',\n 19 => 'Uncanny_Automator\\\\Automator_Recipe_Process_Complete->trigger,',\n 20 => 'Uncanny_Automator\\\\Automator_Recipe_Process_Complete->add_backtrace_property',\n)",
"attributes": {
"code_language": "PHP"
}
}
]
}
]
}
]
},
"actions": {
"items": [
{
"type": "action",
"id": 5140,
"integration_code": "GOOGLESHEET",
"code": "SHEET_ADD_ROW_V2",
"status_id": "completed-with-errors",
"is_deleted": false,
"title_html": "<div><span class="item-title__normal">Create a row in a </span><span class="item-title__token" data-token-id="SHEET_ADD_ROW_V2_META" data-options-id="SHEET_ADD_ROW_V2_META">Google Sheet</span></div>",
"can_rerun": false,
"can_run_now": false,
"can_cancel": false,
"item_log_id": "2",
"fields": [
{
"field_code": "GSSPREADSHEET",
"type": "select",
"label": "Spreadsheet",
"attributes": [],
"value": {
"readable": "newblog",
"raw": "1rIaKgJE0FCibqXCK_5jvo1l-tZNyL_SvbOLso4Iy2sc",
"parsed": "1rIaKgJE0FCibqXCK_5jvo1l-tZNyL_SvbOLso4Iy2sc"
}
},
{
"field_code": "GSWORKSHEET",
"type": "select",
"label": "Worksheet",
"attributes": [],
"value": {
"readable": "Sheet1",
"raw": "9516aa4ad",
"parsed": "9516aa4ad"
}
},
{
"field_code": "WORKSHEET_FIELDS",
"type": "repeater",
"label": "Row",
"attributes": [],
"value": {
"readable": "",
"raw": "[{\"Column\":\"Title\",\"Value\":\"\"},{\"Column\":\"URL\",\"Value\":\"\"},{\"Column\":\"Description\",\"Value\":\"\"},{\"Column\":\"Date Published\",\"Value\":\"\"}]",
"parsed": "[{\"Column\":\"Title\",\"Value\":\"\"},{\"Column\":\"URL\",\"Value\":\"\"},{\"Column\":\"Description\",\"Value\":\"\"},{\"Column\":\"Date Published\",\"Value\":\"\"}]"
}
}
],
"start_date": "December 27, 2024 5:13 pm",
"end_date": "December 27, 2024 5:13 pm",
"date_elapsed": {
"elapsed_in_seconds": 0,
"human_time_diff": "1 second"
},
"_timestamp": 1735319630,
"runs": [
{
"date": "December 27, 2024 5:13 pm",
"_timestamp": 1735319630,
"used_credit": true,
"status_id": "completed-with-errors",
"result_message": "Trying to add an empty row.",
"properties": []
}
],
"result_message": "Trying to add an empty row."
},
{
"type": "action",
"id": "5139",
"integration_code": "WP",
"code": "REDIRECT",
"status_id": "completed",
"start_date": "December 27, 2024 5:13 pm",
"_timestamp": 1735319630,
"end_date": "December 27, 2024 5:13 pm",
"title_html": "<div><span class="item-title__normal">Redirect to </span><span class="item-title__token" data-token-id="REDIRECTURL" data-options-id="REDIRECTURL"><span class="item-title__token-label">Redirect URL:</span> https://digitalsplendid.net</span><span class="item-title__normal"> when recipe is completed</span></div>",
"can_rerun": false,
"can_run_now": false,
"can_cancel": false,
"fields": [
{
"field_code": "REDIRECTURL",
"type": "url",
"label": "Redirect URL",
"value": {
"readable": null,
"raw": "https://digitalsplendid.net",
"parsed": "https://digitalsplendid.net"
}
}
],
"runs": [
{
"date": "December 27, 2024 5:13 pm",
"_timestamp": 1735319630,
"status_id": "completed",
"result_message": "",
"used_credit": false,
"properties": []
}
]
}
]
},
"recipe_edit_url": "https://digitalsplendid.net/wp-admin/post.php?post=5135&action=edit",
"log_delete_url": "https://digitalsplendid.net/wp-admin/edit.php?post_type=uo-recipe&page=uncanny-automator-admin-logs&recipe_id=5135&run_number=1&recipe_log_id=2&delete_specific_activity=1&wpnonce=733d89212c"
}Hi @rajeevbagra2025,
Thank you for sharing the log. It looks like the action is not sending any values to the spreadsheet:
I’m not sure right now, if this is because the tokens aren’t set up correctly or if there’s an error or conflict that prevents the action from receiving the values. I’m also not sure at this stage if this is an error in Automator because I’m not able to replicate it on our test sites.
Could you share the following?
- A screenshot of the expanded Google Sheet action so that I can see the tokens.
- Your site’s PHP error log or
debug.log. If you’re not sure where to find it, kindly contact your hosts.
Best
Here is the error log: https://drive.google.com/file/d/1FmA_unwuYYLG7IAkoKkG36ebzrEsENT3/view?usp=sharing
Screenshot of Google Action: https://www.canva.com/design/DAGa2Q0DL84/4BxPHbXCG54oFyudhXfoXA/edit?utm_content=DAGa2Q0DL84&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton
Thanks!
Postponing the use. Thanks for the support.
- You must be logged in to reply to this topic.
