A: Hi, thanks for your question. You can use the API query feature in Uniquery to connect with WordPress and WooCommerce. This allows you to integrate and retrieve data from WordPress/WooCommerce APIs directly into Google Sheets. Simply use the API query section within the Uniquery addon, select your connection, configure the required query parameters, and execute your query to fetch data from these platforms into your spreadsheet.

To use the API query feature to connect WordPress or WooCommerce with Uniquery in Google Sheets, follow these steps:

1. Open your Google Sheets and navigate to Extensions > Uniquery to open the Uniquery add-on.
2. In the Uniquery sidebar, use the features for creating API queries. Uniquery allows you to connect to APIs via HTTP requests (GET, POST, PUT, PATCH, DELETE) and fetch/import data in JSON or CSV format into your spreadsheet. This is ideal for integrating third-party platforms like WordPress and WooCommerce, which expose their data via API endpoints.
3. Configure your API request:
Set the request URL to the endpoint provided by your WordPress or WooCommerce site.
Specify the required authentication (such as OAuth or API keys) as needed.
Define request parameters, headers, or request bodies as required by the specific API.
4. Customize your import:
You can use cell references for dynamic query customization.
Schedule data refreshes to keep your sheets up-to-date automatically (hourly, daily, weekly).
Choose the destination sheet and map imported fields to your preferred columns 1 .
5. Monitor your queries:
The “In this spreadsheet” tab in Uniquery lets you view all queries running in your Google Sheets file, including API queries.

This workflow allows you to automate the import and management of your WordPress or WooCommerce data directly inside Google Sheets for reporting, analysis, or business operations.
Let me know if you need more information!