Kütüphane / Sosyal Medya Yayıncılığı
Sosyal Medya Yayıncılığı
Gemini ile Google Sheets konularını LinkedIn, Facebook ve Bluesky'da yayınlayın
Hafta içi saat 09:00'da çalışır: Gemini, hazır Google Sheets konularından gönderiler yazar, bir görsel oluşturur ve PostWire, içerikleri LinkedIn, Facebook ve Bluesky'da yayınlar.
Ne yapar
## Write LinkedIn posts with an AI image and post them from a list of topics Turn topics from Google Sheets into LinkedIn posts with their own image: every weekday Gemini writes the post, Nano Banana draws the image and PostWire publishes both on LinkedIn, Facebook and Bluesky. ### How it works 1. Every weekday at 9:00 reads the rows marked ready. Take the next topic picks the first and Mark the topic as writing claims it. 2. Write the posts with Gemini returns a LinkedIn post, a shorter Facebook and Bluesky version and the brief for the image. 3. Nano Banana image (Gemini) generates the image from that brief. 4. Post to LinkedIn, Facebook, Bluesky (PostWire) uploads the image and publishes each text on its network. 5. Mark the topic as posted writes the post links in the row. When the image or a network fails, Write the fix in the row and Email me the fix tell you what to fix. ### Setup 1. Install the verified PostWire node (search "PostWire" in the nodes panel), create an account at postwire.io, connect your networks and paste your API key into a PostWire API credential. 2. Add a Google Gemini credential to both Gemini nodes. The text fits the free tier; a Nano Banana image costs about 0.04 USD. 3. Create a sheet with the columns topic, notes, status, posted_at, links and note. Write ready in status to queue a topic, and pick the sheet in the four Sheets nodes. 4. Connect Gmail and fill in Post settings. ### Customize Change the voice and image style in Post settings, or the networks in the PostWire node (the free plan posts to 2 networks per post).
Adımlar
- Every weekday at 9:00
- Post settings
- Read the topics
- Has a topic
- Take the next topic
- Mark the topic as writing
- Write the posts with Gemini
- Read the plan
- Nano Banana image
- Post to LinkedIn, Facebook, Bluesky
- Collect the results
- Everything published?
- Mark the topic as posted
- Write the fix in the row
Toplam 15 adım.
Benzer otomasyonlar
Sosyal Medya YayıncılığıÜst Reddit konularını OpenAI ile LinkedIn, Facebook ve Bluesky gönderilerine dönüştür15 adımE-posta OtomasyonuRewrite top Instagram posts for LinkedIn, Facebook and Bluesky with Apify and OpenAI19 adımE-posta OtomasyonuPost daily AI news commentary to LinkedIn, Bluesky and Mastodon with Gemini21 adımSosyal Medya YayıncılığıBluesky'da görselli gönderi yayınlama48 adım