Keyword Sync is a powerful feature that allows you to manage your keywords through a Google spreadsheet. This tool is especially useful for users who frequently update their keywords, prices, need to enable or disable terms regularly or manage large keyword sets across multiple campaigns.
It’s highly recommended that you backup your entire uBuyFirst instance and export your current keywords before attempting to use the sync feature.
Benefits
- Team Collaboration: Share and collaborate on keyword management with team members
- Easier Management: Manage keywords from a single spreadsheet rather than the keyword interface
- Batch Updates: Make changes to multiple keywords simultaneously
- Automation Potential: Integrate with other systems through Google Sheets
Setting Up Your Google Sheet #
Recommended Method: Start with Existing Keywords
- Your current keyword export will already have the correct column headers and format
- Export your current keywords from the app (in the Keywords section, look for an “Export” option)
- Import or copy/paste the exported file into Google Sheets
- In Google Sheets grant access to anyone with the link and copy the link
- Go to Sync > Sync Search Terms in uBuyFirst app
- Paste the google sheet URL
- Test by clicking “Fetch and Apply”
- Set the autofetch interval (how often the google doc will be synced)
- Enable auto fetch
Note: All your existing search terms will be replaced by search terms from spreadsheet. Please, create a backup of your uBuyFirst before making changes and export current keywords to be safe.
Note:
- Keyword sync only works one way from Google Sheet to uBuyFirst
- When keyword sync is enabled, existing keywords will be removed.
- Any edited/deleted/created keywords within uBuyFirst will be overwritten the next time the sheet syncs.
