Upload Blog Post in Bulk using Google Sheets and Google Docs

[Ckm]

Is it possible to upload a blog post from a google doc?

I have a google sheet with all the blog posts mapped (tag, category, date, slug, etc.), it works well, but I need to add the content of the blog post inside a google sheet cell. I would like to have the proper formatting from a google doc instead (I don't want to loose all the formatting).

> How can I get the content from a google doc? Can add the link in the google sheet and get it, or are there any other steps I need to do before this?
> Same with the image, do I first need to upload all the images in WP or can I get them with a link from a google drive?

Thank you!

 

[Preeti Paryani]

Hello @Ckm

Are you manually creating each Google Doc or is it getting created via automation?

How can I get the content from a google doc? Can add the link in the google sheet and get it, or are there any other steps I need to do before this?

Yes, you can get publically accessible image links from Google Drive using the "Share file with anyone action".

Same with the image, do I first need to upload all the images in WP or can I get them with a link from a google drive?

Also, we have dedicated video tutorials similar to your queries you can refer to them by following this link - https://www.youtube.com/@Pabbly

However, please let us know the exact use case this would enable us to better assist you.

 

[Ckm]

Hi Preeti, we created a lot of different blog posts in google docs (each one of them), so they have been already created and reviewed.

How does the share file work, is that another step I need to add?

Thank you!

 

[Preeti Paryani]

Hello @Ckm

It seems that in this case you would be required to add the Google Docs link to the Google Sheets manually.

we created a lot of different blog posts in google docs (each one of them), so they have been already created and reviewed.

Please refer to this tutorial to learn about the action -

How does the share file work, is that another step I need to add?

 

[Ckm]

Hello @Ckm

It seems that in this case you would be required to add the Google Docs link to the Google Sheets manually.


Please refer to this tutorial to learn about the action -

Yes, I have all the links of the google docs in my google sheets.
So, if I understand correctly, I would have to use the Filter by Pabbly action before I get the information from my google sheets, is this correct?

> I'm not sure I understand how I can perform this action. In the video she shows an email address. I only have the google sheet with the google doc link, can I fetch the google doc with this link? Thanks!

 

[Ckm]

Here is where I am so far. Am I in the right track? What goes in the post content? Do I need another step? Thanks!

 

[Ckm]

Ok, I added this extra step as in the video. What goes in the post content? Thanks!

 

[ArshilAhmad]

Please check out the thread shared below:

Google Sheets > Google Docs > WordPress

I have a Google Docs URL stored in a Google Sheet. I want to copy all content from the Google Doc and use it to create a WordPress post ("Post Content"). I have the Google Sheets trigger and the WordPress "Create a Post" action, but how can I get the content from Google Docs? Thank You!

forum.pabbly.com