n8n

How to Generate Printify Content from Google Sheets?

Stop writing product titles by hand. Generate and publish product titles and descriptions for Print on Demand products using a simple Google Sheet. Ideal for ecommerce teams that want faster listing updates with clear brand voice.

On a manual run, the flow pulls your Printify shops and products, then breaks them into batches. Brand rules are set once, and OpenAI writes multiple title and description options for each product. Options are saved to Google Sheets so your team can review and choose. When the upload column changes, a Google Sheets event pushes the selected copy back to Printify using an API update. The LLM can also use Wikipedia and a calculator tool to enrich copy with facts or quick math.

You need a Printify API token, a Google Sheet, and an OpenAI API key. Update the brand guidelines and set how many options to create before running it on your catalog. Expect faster product refreshes, consistent tone, and better SEO on product pages. Great for seasonal launches, bulk edits, and testing copy across many items.

What are the key features?

  • Google Sheets Trigger watches an upload column and starts updates when you change a row
  • Manual path fetches shops and products from Printify and loops through them in batches
  • Set node stores brand name, tone, and custom rules for consistent writing
  • OpenAI generates multiple title and description options per product
  • Wikipedia and calculator tools give the AI quick facts and simple math when needed
  • Options are written to Google Sheets for review and selection
  • API call updates the chosen title and description back to Printify with a PUT request
  • If and calculation nodes control how many options to create and when to loop

What are the benefits?

  • Reduce manual copywriting from 30 minutes to 3 minutes per product
  • Automate about 80 percent of listing edits using a simple sheet
  • Improve data accuracy by removing copy and paste errors
  • Handle up to 10 times more products with batch processing
  • Connect Google Sheets, OpenAI, and Printify in one flow

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets, Printify, OpenAI and Wikipedia. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, create Google Sheets OAuth2 credentials. Double click a Google Sheets node, choose 'Credential to connect with', click 'Create new credential', and follow the prompts to approve access to your Google account.
  4. Create Printify credentials as HTTP Header Auth. Open your Printify account to create an API token, then in n8n choose 'HTTP Header Auth', set Header Name to 'Authorization' and Value to 'Bearer YOUR_TOKEN'. Save and test.
  5. Create OpenAI credentials. In your OpenAI account, generate an API key. In n8n, open the OpenAI node, click 'Create new credential', paste the API key, and save.
  6. Open the Set node named Brand Guidelines and enter your brand name, tone, keywords, and any custom instructions you want the AI to follow.
  7. In the Number of Options node, set how many title and description options you want for each product.
  8. Configure the Google Sheets Trigger node. Set Document ID and Sheet name to your sheet. Make sure the trigger watches the 'upload' column as shown in node options.
  9. Run a test: click Test workflow to pull Printify products. Confirm the GS Add Product Option and Update Product Option nodes write option rows into your Google Sheet.
  10. Pick a product in the sheet, copy the preferred option into product_title and product_desc, then change the upload cell to TRUE. Wait up to one minute and verify the Printify product updates.
  11. Troubleshoot: if products do not appear, check the Printify token and shop access. If updates fail, confirm product_id matches Printify and your header auth is correct. Review execution logs, and reduce batch size if you see rate limits.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Printify

Sign up

Free plan: $0 / mo (API access via Personal Access Token)

Wikipedia

Sign up

Free: $0 (public Wikimedia APIs). Enterprise Free: $0 with 5,000 on‑demand requests / mo and twice‑monthly snapshots

Credits:
Creator: Alex Kim. About me: https://beacons.ai/alexk1919

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.