WPSyncSheets For Core

Yes. You can export all of your existing posts to your Google Spreadsheet by clicking the “Click to Sync” button on the WPSyncSheets For Core settings page.

The “Click to Sync” button is designed only to export data from WordPress to your Google Sheet. It does not import or update changes from the spreadsheet back to WordPress.

• To Import manually: Enter 1 in the Update column for the rows you want to update (or 1 in the Insert column for new rows) inside your Google Sheet. Go to WordPress Dashboard -> WPSyncSheets -> Import, and run the import.
• To Import automatically: Enable the Schedule Auto Import feature in the settings. This allows the plugin to automatically scan the spreadsheet at regular intervals and apply changes.

No. You should not manually reorder, add, or edit the columns directly inside Google Sheets, as this will break the data mapping and cause sync errors or mismatched data. If you want to rearrange or add columns, you must use the drag-and-drop builder under the Header Settings tab in the plugin settings and click Save. This will automatically rearrange the columns in your Google Sheet.

This error occurs when your Google Sheet does not contain enough columns to accommodate all the fields you selected in the plugin settings.

• Solution: Open your Google Sheet, manually add several blank columns to the right side of the sheet, and save your header settings again in WordPress.

Yes. However, importing a very large number of posts (e.g., 5000+ posts) in a single run can cause server timeouts. Clear the Post ID column in the spreadsheet if you want to import them as new posts. Then, set the Insert column to 1 for a small test batch of 5 to 10 posts. Do not run a bulk import all at once; process them in smaller batches or use the Schedule Auto Import feature to let the background cron job process them gradually.

Enable the Schedule Auto Import feature in the settings. Ensure you add 1 in the Insert, Update, or Delete columns in your Google Sheet for the rows you want to process. The background cron job (configured to run at your chosen interval, e.g., every 10 minutes) will automatically detect these rows and apply the updates.

This error occurs during import when you attempt to insert a new post but have a value in the “Post ID” column of the spreadsheet. If the column contains an ID, WordPress will try to update that existing post instead of creating a new one. To insert a new post, leave the Post ID cell completely blank.

This error occurs when Google Sheets reaches its default row limit (usually around 1000 rows) and cannot accommodate more synced posts. To resolve this, open your Google Sheet, scroll to the very bottom, locate the “Add more rows” box, enter 1000 (or more), and click Add. Then try syncing or importing again in WordPress.

Yes. Enter the full direct URL of the external image (e.g., https://example.com/image.jpg) in the Featured Image column of the Google Sheet. On import, the plugin will download the image, upload it to your WordPress Media Library, and assign it to the post. Note that Google Drive file links are not supported as they do not point directly to the raw image file.

Yes, the plugin has built-in compatibility with FIFU. You can import external image URLs from the spreadsheet, and the plugin will update the featured image via FIFU without breaking or overwriting the external link structure.

This warning is shown because the OAuth app you created in your Google Developer account hasn’t been verified by Google. Since you created it and it’s running under your account, it is perfectly safe.

• To bypass this, click Advanced at the bottom-left of the warning screen, and then click Proceed to [Your App Name] (unsafe).

It is not recommended to clear the sheet manually.

Please use the Clear Spreadsheet button provided in the plugin.

If you absolutely must clear the sheet manually, make sure to keep the header row intact. The plugin depends on the header row for mapping and syncing.