How make Scan QRCode and Save it in Google Sheet using Google App Script Android Studio

Step 1: Create new app script project. Click here to create App Script.

Step 2: Copy and paste the below script which recieves scanned data  and inserts in Google Sheet.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

function doGet(e){   var ss = SpreadsheetApp.openByUrl("Your Spread Sheet URL");   var sheet = ss.getSheetByName("Sheet1"); return insert(e,sheet); } function doPost(e){   var ss = SpreadsheetApp.openByUrl("Your Spread Sheet URL");   var sheet = ss.getSheetByName("Sheet1");   return insert(e,sheet); } function insert(e,sheet) {   var scannedData = e.parameter.sdata; var d = new Date();   var ctime =  d.toLocaleString();      sheet.appendRow([scannedData,ctime]);      return ContentService   .createTextOutput("Success")   .setMimeType(ContentService.MimeType.JAVASCRIPT);         }

Step 3: Change the url of the spread sheet. Make sure sheet is shared .[anyone with the link can view]

Step 4: Go to Publish -> Deploy as web app. A window pop up, here ->Who has access to the app: ->  Anyone,                   even Anonymous

            Publish/Update. Copy the published URL and store it.

2. Android Part

Step 1: Create new Android App from Android Studio

Step 2: Go to build.gradle[module: app] and add following dependencies.

note: If you are downloading the source code and modifying. Please make sure build tool version and compileSdk Version in build.gradle[module: dependancyapp] are compatible with your phone. If you are developing from the scratch then no issues, just dependency,

1 2	compile 'com.google.zxing:core:3.3.0' compile 'com.journeyapps:zxing-android-embedded:3.4.0'

Step 3: Let’s add all layout files.

activity_main.xml  This adds a button to Scan

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

<?xml version="1.0" encoding="utf-8"?> <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"     xmlns:tools="http://schemas.android.com/tools"     android:layout_width="match_parent"     android:layout_height="match_parent"     android:paddingBottom="@dimen/activity_vertical_margin"     android:paddingLeft="@dimen/activity_horizontal_margin"     android:paddingRight="@dimen/activity_horizontal_margin"     android:paddingTop="@dimen/activity_vertical_margin"     tools:context="alabs.qsg.MainActivity">     <TextView         android:layout_width="wrap_content"         android:layout_height="wrap_content"         android:text="QR SCAN TO GSHEET"         android:layout_alignParentTop="true"         android:layout_centerHorizontal="true"         android:id="@+id/textView" />     <Button         android:layout_width="wrap_content"         android:layout_height="wrap_content"         android:text="SCAN"         android:id="@+id/scan_btn"         android:layout_below="@+id/textView"         android:layout_centerHorizontal="true"         android:layout_marginTop="80dp" /> </RelativeLayout>

Step 4: add the following code to MainActivity.java which scans and calls web service

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

package alabs.qsg; import android.app.Activity; import android.content.Intent; import android.os.AsyncTask; import android.os.Bundle; import android.support.v7.app.AppCompatActivity; import android.util.Log; import android.view.View; import android.widget.Button; import android.widget.Toast; import com.google.zxing.integration.android.IntentIntegrator; import com.google.zxing.integration.android.IntentResult; import org.json.JSONObject; import java.io.BufferedReader; import java.io.BufferedWriter; import java.io.InputStreamReader; import java.io.OutputStream; import java.io.OutputStreamWriter; import java.net.HttpURLConnection; import java.net.URL; import java.net.URLEncoder; import java.util.Iterator; import javax.net.ssl.HttpsURLConnection; public class MainActivity extends AppCompatActivity {     String scannedData;     Button scanBtn;     protected void onCreate(Bundle savedInstanceState) {         super.onCreate(savedInstanceState);         setContentView(R.layout.activity_main);        final Activity activity =this;         scanBtn = (Button)findViewById(R.id.scan_btn);         scanBtn.setOnClickListener(new View