If you want to auto-post links from Google Sheets to WordPress as new posts, here are the steps. We will use WordPress Automatic plugin to import every added link as a new post to our WordPress site

1- Create your Google sheet that contains the links that you will Import

2- From the File > Share, select “Publish to the Web”

this should give you a link that we can use to grab the saved URLs from

4- Select “Comma separated values”

5- Copy the link

6- Create a new Multi-Scraper campaign to post from this link and use REGEX as the links extraction method and use this REGEX

https?://[^\s]*

7- Publish your campaign

Now the plugin will check this Google sheet for any new links added and import every link added to the sheet as a new post