WP Smart Import Pro allows you to import data directly from live cloud spreadsheets and remote file feeds. Instead of repeatedly downloading CSV or XML files to your computer and uploading them manually, you can paste a Google Sheets, Google Drive, Dropbox, or HTTP feed URL once, map your template, and keep your WordPress content or WooCommerce inventory continuously synchronized.
💡 Why Use Google Sheets with WP Smart Import Pro?
- Real-time Stock & Price Updates: Edit prices and quantities in your Google Sheet on your phone or laptop; WP Smart Import Pro syncs them to your live website automatically on schedule.
- Team Collaboration: Multiple suppliers or inventory managers can update one shared Google Sheet without ever needing access to your WordPress admin panel.
- Automatic Conversion: No manual export needed—WP Smart Import Pro converts Google Sheets directly to fast, secure XML streams behind the scenes.
Supported Google Sheets Link Formats
WP Smart Import Pro automatically recognizes and normalizes the following Google Sheets link types:
Option 1: Standard Share Link (Recommended & Simplest)
This is the standard link generated when sharing a sheet with your team:
https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit?usp=sharing
WP Smart Import Pro extracts the document ID and tab GID, converting it automatically into a live downloadable CSV export stream.
Option 2: “Publish to the Web” CSV Link (Best for High-Frequency Cron)
If you run high-frequency recurring imports (e.g. hourly cron sync), Google’s published web link offers the fastest CDN response times:
https://docs.google.com/spreadsheets/d/e/2PACX-1vR-EXAMPLE-pub-ID/pub?output=csv
Option 3: Specific Sheet Tab Link (Using GID)
If your spreadsheet contains multiple tabs (worksheets), copy the URL while viewing that specific tab. The URL will contain a #gid=... or ?gid=... parameter:
https://docs.google.com/spreadsheets/d/YOUR_DOC_ID/edit#gid=198420134
WP Smart Import Pro will target that specific sheet tab and import only its rows.
Step-by-Step Guide: How to Import from Google Sheets
Step 1: Set Google Sheet Sharing Permissions
Because your WordPress server connects to Google Sheets without asking you to sign in every time, your Google Sheet must be accessible via public link:
- Open your spreadsheet in Google Sheets.
- Click the blue Share button at the top-right corner.
- Under General access, change “Restricted” to “Anyone with the link”.
- Leave the role set to Viewer (WP Smart Import only needs read access).
- Click Copy link and then Done.
Step 2: Enter URL in WP Smart Import
Go to your WordPress Admin and click WP Smart Import → New Import (or WooCommerce Import):
- Click on the Download From URL / Google Sheets button.
- Paste your copied Google Sheets URL into the input field.
- Click the Download button.
WP Smart Import Pro contacts Google, fetches the latest sheet rows, automatically converts the data into clean XML format, and displays a success confirmation: “File is Ready to use”.
Step 3: Build Your Template & Run the First Import
Click Continue to Step 2 to preview the columns, then Continue to Step 3 to drag and drop your spreadsheet columns into WordPress posts, pages, or WooCommerce product fields. Proceed to Step 4 to complete your first import.
Setting Up Automated Recurring Sync with Cron
Once your initial import is created, you can set it to update automatically whenever your Google Sheet changes:
- Navigate to WP Smart Import → Manage Schedules.
- Locate your Google Sheets import in the table and click Add / Edit Schedule.
- Choose your desired frequency:
- Hourly: Ideal for fast-changing stock and prices.
- Twice Daily: Morning and evening syncs.
- Daily / Weekly: For new product additions or blog posts.
- Custom Cron Expression: For exact schedule timing (e.g.
0 */2 * * *for every 2 hours).
- Enable Automatic Re-download Source Feed.
On every scheduled execution, WP Smart Import Pro re-contacts Google Sheets, retrieves the newest spreadsheet data, updates existing records, and adds any newly created rows without any manual work!
Troubleshooting Tips
Error: “Failed to download the remote file”
Ensure that your Google Sheet’s General Access is set to “Anyone with the link can view”. If it is set to “Restricted”, Google’s servers reject download requests with a 403 error.
My Sheet Has Multiple Tabs—How Do I Select the Second Tab?
Click on the tab inside Google Sheets before copying the URL. Ensure the URL ends with #gid=XXXXX or ?gid=XXXXX. WP Smart Import will import only that specific worksheet.