WPSyncSheets For Bricks

This usually happens when your Google Sheet does not contain any header row.
 To fix this:

1. Go to your Header Settings inside the plugin.
2. Make a small change and save the settings again.

This will automatically regenerate the required headers and the sync/update process will work correctly.

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.

This error occurs when your sheet doesn’t have enough columns.

Solution:

Add a few blank columns to the right of your last column, then try saving the settings again. The error will be resolved once the sheet has enough column space.

Please visit link Click Here.

No, We can’t reorder / add / edit the sheet header columns because it will be miss match the entry data.

1. Make sure you have allowed all the checkboxes when generating the authentication code.
2. Make sure you publish the app

Please add 2000 more rows to your sheets. Please check with the below screenshot.

If the header row still doesn’t update:

1. Go to Header Settings.
2. Add or remove a header field (any small change).
3. Save the settings again.

This forces the plugin to rebuild and refresh the header row in the sheet.

There are following ways to resolved this error:

1. Revoke token at Google API Settings Page.
2. Check the Google Drive API must be Enable

After saving the action settings, please refresh the page to load the updated settings properly.
If you selected “Create New Spreadsheet”, refreshing the page will automatically switch the option back to “Existing Spreadsheet” and display the newly created spreadsheet in the dropdown list.