Title: render to google sheet
Last modified: January 12, 2025

---

# render to google sheet

 *  Resolved [hossam91](https://wordpress.org/support/users/hossam91/)
 * (@hossam91)
 * [1 year, 5 months ago](https://wordpress.org/support/topic/render-to-google-sheet/)
 * when user submit order his details saved to google sheet
 * but i see some data are shorten like country
 * i see US instead of united state
 * and payment method is bacs instead of bank transfer
 * is there a way to render the full data to g-sheet

Viewing 1 replies (of 1 total)

 *  Plugin Support [wayes001](https://wordpress.org/support/users/wayes001/)
 * (@wayes001)
 * [1 year, 5 months ago](https://wordpress.org/support/topic/render-to-google-sheet/#post-18240011)
 * Thank you for reaching out to us.
 * We have reviewed your issue and found that the data being sent to Google Sheets
   is based on the backend values used by WooCommerce. For example:
    - The **country** is sent as “US” instead of “United States” because WooCommerce
      uses the country code “US” in its backend.
    - The **payment method** is sent as “bacs” instead of “Direct bank transfer”
      since it also uses this value internally.
 * To display the full names or titles in Google Sheets, we recommend using the **
   Payment Method Title** field instead of the Payment Methods. This will provide
   the full title, such as “Direct bank transfer,” rather than “bacs.”
 * Unfortunately, WooCommerce sends country codes by default to render full country
   names.

Viewing 1 replies (of 1 total)

The topic ‘render to google sheet’ is closed to new replies.

 * ![](https://ps.w.org/bit-integrations/assets/icon-256x256.gif?rev=3291200)
 * [Bit integrations - Form Integration, Webhook, Spreadsheets, CRM, LMS & Email Automation](https://wordpress.org/plugins/bit-integrations/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/bit-integrations/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/bit-integrations/)
 * [Active Topics](https://wordpress.org/support/plugin/bit-integrations/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/bit-integrations/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/bit-integrations/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [wayes001](https://wordpress.org/support/users/wayes001/)
 * Last activity: [1 year, 5 months ago](https://wordpress.org/support/topic/render-to-google-sheet/#post-18240011)
 * Status: resolved