GSheets>Wordpress

[Coda123]

Hi I'm getting the following errors message (Image also) on trying the send posts from Google Sheet rows to Wordpress.

Code - rest_cannot_create
Message - Sorry, you are not allowed to create posts as this user.
Data Status - 401

I have downloaded the Basic Authentication handler for the JSON API to WordPress as well as the add-on for google sheets.

My google spreadsheet only has the following fields...
Title | Content | Image URL

What I want to do is create a WordPress post for every row created in google sheets? this is after an online form is update and data sent to google sheets.

Any help appreciated.

 

[Coda123]

Help, Help, Help......................

Any help with the the above please, before I'm forced to move on to another service. Love the concept of Pabbly but cannot commit to purchase what I cant get help to fix the issue here: GSheets-Wordpress.1435

 

[Pabblymember11]

Hey @Coda123

We looked at your workflow and the WordPress action step. It looks like your WP account might have a password authentication issue. Though we have tested this too at our end and found the issue is from in WP account with the ht-access file or with your account.

So, please contact with WordPress team regarding this and they will be able to assist you better. Do share the below screenshot as well of the error.

Reference website - https://github.com/WP-API/node-wpapi/issues/349

 

[Coda123]

Got it working by following….. https://github.com/WordPress/application-passwords/wiki/Basic-Authorization-Header----Missing
Updating ftp table in web host supplier.