Dits.Agency

Stop wasting time on manual product updates. AI Import Products from Google Sheets for WooCommerce helps you import WooCommerce products from Google Sheets or CSV with flexible field mapping, safe batch processing, optional image sync, and AI-powered content generation.
<h4>Key Features</h4>
<ul>
<li>Import products from Google Sheets or CSV (mapping: SKU, title, description, price, status, etc.)</li>
<li>Batch processing for large catalogs (safer for servers)</li>
<li>Optional images sync (Google Drive folder column)</li>
<li>Optional AI content assistant (OpenAI): generate Title / Short / Full using your prompts</li>
<li>Works with multilingual WordPress installs (UI can be translated)</li>
</ul>
<h4>AI Content Assistant (Optional)</h4>
To generate product content you need your own OpenAI API key (paid service). You fully control prompts and the target language inside prompts.
<h4>Free vs PRO</h4>
The free version is perfect to start. PRO adds advanced automation (multiple sheets + scheduled imports).
Free 
* 1 sheet per website 
* Manual update (Run now)
PRO 
* Unlimited sheets 
* Scheduled imports (daily / weekly / monthly)
<h3>Privacy / External Services</h3>
This plugin can connect to external services:
1) Google APIs (Google Sheets / Google Drive) 
Used to read spreadsheet data for import and (optionally) to fetch images from a Google Drive folder. 
This happens only when an administrator connects Google and starts an import / image sync.
2) OpenAI API (Optional) 
If enabled, the plugin sends your prompt and selected product fields to OpenAI to generate content. 
You must provide your own OpenAI API key.
This plugin does not collect telemetry and does not send any data to the developer’s servers.
Service privacy policies: 
– Google: https://policies.google.com/privacy 
– OpenAI: https://openai.com/policies/privacy-policy

AI Import Products from Google Sheets for WooCommerce

Import WooCommerce products from Google Sheets or CSV with flexible field mapping, safe batch processing, optional image sync, and AI-powered content  …

sheetdb

The SheetDB wordpress plugin allows you to easily add content from Google Spreadsheet to your wordpress site. To add content, simply add shortcode that looks like this – <code>[sheetdb url=&#34;https://sheetdb.io/api/v1/YOUR_API_ID&#34;][/sheetdb]</code>. Content from within will be rendered as many times as there are rows in the spreadsheet (excluding the first row, which are column names – definition). Each time a new row is rendered, you can refer to any value using the braces notation: <code>{{column_name}}</code>
Example spreadsheet: <a href="https://docs.google.com/spreadsheets/u/3/d/1YiMOrIFnMaksK032-zv6Sch2tTVTRhEpsFom_5qSLXM/edit" rel="nofollow ugc">Example spreadsheet document</a>
Example code: 
[sheetdb url="https://sheetdb.io/api/v1/58f61be4dda40" element="ul" limit=3 search="id=*" sort-by="id" sort-order="desc" lazy-loading="true"] 
{{id}} – {{name}} 
[/sheetdb]
You can use following optional attributes: 
 * limit – The number of rows that should be returned 
 * offset – Row from which it should start (how many rows to skip) 
 * sheet – If you want to use a different sheet than the first one (default), enter the name of the tab you want to use here. 
 * search – You can search for specific data in your sheet. If you want to use more than one condition join them using & symbol. Example: search="name=Tom&age=15" 
* sort-by – The column you want to sort by 
* sort-order – sort in <code>asc</code> or <code>desc</code> order 
* lazy-loading – If you set this attribute to true, the api call will be executed only when the user reaches the point of the table. If your table is lower on the page this can help reduce request consumption.
HTML rendering and safety: 
* Using <code>{{name}}</code> renders plain text only. Any HTML is escaped and will not be executed or rendered. 
* Using <code>{{html:name}}</code> allows most safe HTML tags to render (e.g. <code>a</code>, <code>p</code>, <code>ul</code>, <code>li</code>, <code>strong</code>, <code>em</code>, <code>img</code> with safe attributes). Potentially dangerous tags and attributes (e.g. <code><script></code>, <code><iframe></code>, <code><object></code>, <code><embed></code>, inline <code>on*</code> event handlers, and <code>javascript:</code> URLs) are stripped/sanitized.
This behavior is intentional for security reasons to prevent XSS and code injection from spreadsheet content.
Security recommendation: 
* For best security, configure your SheetDB API as read-only: enable only <code>GET</code> and disable <code>POST</code>, <code>PATCH</code>, and <code>DELETE</code>. This prevents anyone from modifying your data via exposed API keys or URLs.
Additional information: 
This plugin use SheetDB.io to fetch data from Google Spreadsheet. You must have an account at SheetDB – account is free for 500 requests per month. More information at <a href="https://sheetdb.io" rel="nofollow ugc">SheetDB.io</a> or at <a href="https://sheetdb.io/privacy-policy" rel="nofollow ugc">privacy policy</a>
<h3>Re-use</h3>
If you want to re-use your data, you can use the <code>save</code> attribute in your [sheetdb] element. To re-use your data use [sheetdb-slot]. You can use the same data inside as in the parent. To match them the value of save and slot must be the same.
Example:
[sheetdb url="https://sheetdb.io/api/v1/58f61be4dda40" save="slot-name"]
{{id}} – {{name}}
[/sheetdb]
[sheetdb-slot slot="slot-name"]
{{name}}
[/sheetdb-slot]
That way, you only use 1 request instead of 2. Slots have access to the same data as the parent. You can’t change things like limit or search.

SheetDB – get your Google Spreadsheet data

Where have you been these past months (years) while I searched and searched for such a plugin?   This does exactly what I, and a zillion others, have needed, desired, and waited for!  It is awesome!  Thank you.  Thank you.  Thank you!

Everyone, if you've been seeking a way to display your form data on a WP page, look no more!  This will do the trick.  Your wait is over.

I've only downloaded and installed it today, so I can't quite know all it's features.  However, out of the box and with a few simple tweaks, I have accomplished in moments what I've tried to do for months!

Thank Goodness!

The SheetDB wordpress plugin allows you to easily add content from Google Spreadsheet to your wordpress site.

AI Import Products from Google Sheets for WooCommerce vs SheetDB – get your Google Spreadsheet data