Routing Quote Request to Google Sheet

Hi,

Thanks for the detailed write-up.

1) No, HikaShop has no native Google Sheets connector, and we don't bundle or officially resell a third-party one for it.

2) You don't actually need a third-party plugin. HikaShop Business already has what you need in the Mass actions feature (System > Mass actions). Create a mass action with:

- Trigger: "After an order is created" (or "After an order is confirmed" if you only want submitted quotes).
- Action: "Send HTTP request", which lets you POST the order data to any URL, with your own headers and a body where you can inject fields with placeholders like {order_id}, {order_number}, etc.

The simplest sink for the Sheet is a Google Apps Script Web App: deploy a small script with a doPost(e) that calls sheet.appendRow(...), and point the mass action's HTTP request at its /exec URL. That avoids juggling OAuth tokens on the Joomla side, since the script writes to the Sheet under its own account.

If you prefer to hit the Sheets API directly (spreadsheets.values.append), the "Send HTTP request" action also has a built-in OAuth2 mode (token URL, token request body, token extraction) so it can fetch a bearer token before the call. The Apps Script route is just less work in practice.

There is also a "Run PHP code" action in the same mass action if you want to call the Sheets API straight from PHP using the credentials you already set up.

3) Yes. The reliable hook is onAfterOrderCreate, in a plugin of the "hikashop" group:

public function onAfterOrderCreate(&$order, &$send_email) { ... }

It fires for every new order, including quote requests, since those go through the same order-save path. onAfterOrderUpdate(&$order, &$send_email) is the matching hook for later status changes. This is exactly the event the Mass actions order plugin uses internally, so whichever route you pick (no-code mass action or your own plugin), you are hooking the same point.