LayoutHub
  • What is LayoutHub?
  • User guides
    • Support
    • Installation
    • Uninstallation
    • Upgrade/Downgrade
    • FAQs
      • How to remove instagram section from Layouthub
      • What is "Pages limit"?
      • When can I "Edit code"?
      • What about "Save section"?
      • What is " Auto save draft"?
      • What is "Integration Services"?
      • How to set the same font between Shopify and LayoutHub?
      • How to custom font and color on LayoutHub?
      • How to set "Page handle or human url"?
      • Connective Button
      • How to save page without publish it
      • How to change the meta SEO for LayoutHub's page
    • Common Issues
    • Layout Management
      • Create Layouts
      • Design Blocks
      • Export & Import
      • Edit Section Code
      • Edit a Layout
      • Assign a Layout
      • Duplicate a Layout
      • Delete a Layout
    • Section builder
    • LayoutHub pages/templates
      • Home Page
        • Create additional Home Page
        • Make an existing page as home page
        • Restore to default Home Page
        • Customize Shopify Home Page
      • Sub-page
        • Contact Form
      • Product Template
        • Product Detail
        • Related Product
      • Collection Template
      • Blog Templates
      • Article Templates
      • Insert section
    • Pricing Plans
    • Settings
      • General
      • Theme Settings
      • Quickview Settings
      • Swatch color settings
      • Third party Apps
        • Product Review
        • Product Wishlist
    • Trash
    • Sale Tools
    • Referrals
    • Integration
      • Add/Edit Profile
      • Add New Contact
      • Export Contact
      • Mailchimp
      • Hubspot
      • ActiveCampaign
      • GetResponse
      • SendGrid
      • Gmail SMTP
      • Google Sheets
      • Omnisend
      • Klaviyo
      • ConvertKit
    • Tracking & Analytics
    • Layouthub & Shopify
    • Translate Apps
    • Recommend apps
      • Avada SEO Optimization
      • Ali Reviews ‑ Product Reviews
      • Ryviu: Product Reviews App UGC
      • Quick View by Secomapp
      • LAI AliExpress Reviews
      • Judge.me Product Reviews
      • Growave - Loyalty, Wishlist, Reviews UGC
      • Opinew Product Reviews
    • Refund Policy
    • Instagram token
  • Development
    • Getting started
    • Tools
      • LayoutHub Kit (for LayoutHub developers only)
      • LayoutHub Kit Extension for Visual Studio Code
    • Layout Structure
    • Reference
      • Engine syntax
        • Deprecated: March 2020
        • Chuẩn template má»›i - LayoutHub Editor V4
      • Create a section
      • Components
      • Liquid in section
      • Javascript in section
      • Register vendors
      • Settings.js
        • Call-to-action
        • Text
        • Textarea
        • Text Editor
        • Dropdown
        • Checkbox list
        • Checkbox radio
        • Toggle
        • Number slider
        • Number
        • Single image
        • Image library
        • Color picker
        • Icon picker
        • Font picker
        • Background
        • Picker
        • Group fields
Powered by GitBook
On this page
  • 1. How to create JSON Auth
  • 2. How to get Spreadsheet ID
  • 3. Share the permissions of Google Sheets
  • 4. Spreadsheet Range

Was this helpful?

  1. User guides
  2. Integration

Google Sheets

PreviousGmail SMTPNextOmnisend

Last updated 4 years ago

Was this helpful?

To integrate Google Sheets, you need to get "JSON Auth" and "Spreadsheet ID" information.

1. How to create JSON Auth

+ Create project on

+ Click Enable API and Services

+ Scroll down and click on Google Sheets API

+ Click Enable the Google Sheets API

+ Go to Credentials, then click Create credentials, and select Service account key.

+ Fill all the fields in Service account details form with 3 steps

+ For Key type, choose JSON (the default) and download the file. This file contains a private key so be very careful with it, it is your credentials after all.

Edit the sharing permissions to "Edit" for the spreadsheet you want to access to the client email address you can find in the JSON file.

+ Copy all content in JSON file and paste to JSON Auth field.

2. How to get Spreadsheet ID

Create new Spreadsheet, where you want to send emails to. You can get spreadsheet ID from URL of this spreadsheet file like image below:

3. Share the permissions of Google Sheets

+ Open "Service accounts" and copy the email of the service account that you just created.

+ Go to the Spreadsheet to share the permission to that email:

4. Spreadsheet Range

Range that emails will insert into the spreadsheet. Example for A1:A9

All fields name are supported

If you love LayoutHub, could you consider posting an review? That would be awesome and really help us to grow our business, here is the.

link
https://console.developers.google.com/apis/dashboard