Add Form Fields to googe sheet using google App Scrpts

app_script.js

/*
Create A Google Sheet eand open it, From 'Extensions' Tab Choose Googe App Script
Put the following function in the app script and publish it as web app
*/
function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
  var newRow = headers.map(function(header) {
    return e.parameters[header] ? e.parameters[header].toString() : '';
  });
  sheet.appendRow(newRow);
}

HomeController.php

<?php

namespace App\Http\Controllers;

use Http;

class HomeController extends Controller
{
    use UsingSEO;


    public function apply(Request $request)
    {
        Http::asForm()->post(
            'https://script.google.com/macros/s/GOOGLE_APP_SCRIPT_ID/exec',
            $request->only(['key1', 'key2']), // Same Keys must be in Google Sheet in first rows for sheet headers
        );

        session()->flash('success', trans('main.thanks_for_your_applied'));

        return back();
    }
}