View Live Data Google Sheet

View Live Data Google Sheet module helps us to show Google Sheet data on our drupal site on a page.
It integrates with data table to use search and pagination feature on the data.

REQUIREMENTS
* This module requires no modules outside of Drupal core.

INSTALLATION
* Install the View Live Data Google Sheet module as you would normally install a contributed
Drupal module.

DRUPAL CONFIGURATION
1. Navigate to Administration > Extend and enable the module.
2. Navigate to Administration > Configuration > View Google Sheet data > Sheet Config or /admin/config/gsheet-url to add Deployment Id
3. Add Deployment Id. An Deployment Id is required for the successful integration with
your Google Sheet.
5. After integration, you can simply go to Administration > Configuration > View Google Sheet data or /live-gsheet-data to view the data on your website

STEPS TO GET DEPLOYMENT ID
1. Go to any google sheet you have. For example https://docs.google.com/spreadsheets/d/1skcvtZOT-rDEV5vlKO5DseWkBab3uhWN...
2. Click on extension on menu bar of google sheet and select Apps Script
3. Copy this code and paste this on Code.gs

function doGet(){
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  var result = JSON.stringify(data);
  return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON); 
}

4. Now click on deploy button on top sidebar and click new deployment and done
5. Now click on the web app url and which you get once deployment is done.

6. Copy the url after user_content_key

7. Now paste this copied text in the deployment id and click on save configuration