How do I automatically create scheduled posts in ContentStudio from Google Sheets?

Hi ​@davidmartin1, welcome to the Community! 👋

There is indeed an app integration for ContentStudio and it’s got a Create Social Post action that would allow you to schedule the post:

You’d want to use the Google Sheets New Spreadsheet Row trigger for the Zap. Then you’d map the necessary fields that contain the post text, image URL, and publish date from the new row into the ContentStudio action. You shouldn’t need Webhooks by Zapier unless the ContentStudio action doesn’t support one of the fields you need.

Give it a try and let us know how it goes!

Hi everyone, I use ContentStudio to manage and schedule social media posts. I'd like to automate adding content to it:

1. When a new row is added to a Google Sheet (with post text, image URL, and publish date), create a post in ContentStudio and schedule it for that date.
2. Is there an official ContentStudio app on Zapier, and which triggers and actions does it support?
3. If there's no suitable action, can I use Webhooks by Zapier with ContentStudio's API instead? If so, which endpoint and authentication should I use?

Thanks in advance!

Hi ​@davidmartin1, welcome to the Community! 👋

There is indeed an app integration for ContentStudio and it’s got a Create Social Post action that would allow you to schedule the post:

You’d want to use the Google Sheets New Spreadsheet Row trigger for the Zap. Then you’d map the necessary fields that contain the post text, image URL, and publish date from the new row into the ContentStudio action. You shouldn’t need Webhooks by Zapier unless the ContentStudio action doesn’t support one of the fields you need.

Give it a try and let us know how it goes!