Uncategorized
How to send Website Data to Google Sheet (Without API)
Admin
September 01, 2023
1 views
In this article we will learn how to send website data to google sheet in the most simplest way.
Step 1: Create a Google Form
- Create a new Google Form.
- Add fields that you want to populate from your PHP script. For example, let's say you have two fields: "Name" and "Email".
Step 2: Get Form URL and Field IDs
- Once your form is ready, click on the three dots in the upper-right corner and choose "Get pre-filled link".
- Fill in some sample data and click "Get Link".
- The generated link will have the field IDs you need. It will look something like this:
https://docs.google.com/forms/d/e/[FORM_ID]/formResponse?entry.[FIELD_ID_1]=sampleName&entry.[FIELD_ID_2]=sampleEmail
Step 3: PHP Code
Here's a simple PHP code snippet to send data to Google Sheets using cURL:
<?php
// Google Form URL
$formUrl = 'https://docs.google.com/forms/d/e/[FORM_ID]/formResponse';
// Data to be sent
$data = [
'entry.[FIELD_ID_1]' => 'John',
'entry.[FIELD_ID_2]' => 'john@example.com'
];
// Initialize cURL
$ch = curl_init();
// cURL settings
curl_setopt($ch, CURLOPT_URL, $formUrl);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
// Execute cURL
$result = curl_exec($ch);
// Close cURL
curl_close($ch);
// Output the result (for debugging)
echo $result;
?>Replace [FORM_ID], [FIELD_ID_1], and [FIELD_ID_2] with your actual Form ID and Field IDs.
Full Source Code is Written Below
Google.php Page
<?php
$name = $_POST['name'];
$mobile = $_POST['mobile'];
$email = $_POST['email'];
if (isset($_POST['submit'])) {
// Google Form URL
$formUrl = 'https://docs.google.com/forms/d/e/1FAIpQLSfFOl9BfdtdVHf_hcqe69ZwLKQ6GHWSeDJPaFP9d-2v20FA_Q/formResponse';
// Data to be sent
$data = [
'entry.1027832668' => "$name",
'entry.547919694' => "$mobile",
'entry.981977111' => "$email"
];
// Initialize cURL
$ch = curl_init();
// cURL settings
curl_setopt($ch, CURLOPT_URL, $formUrl);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
// Execute cURL
$result = curl_exec($ch);
// Close cURL
curl_close($ch);
// Output the result (for debugging)
//echo $result;
header("Location: thankyou.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Simple Form</title>
</head>
<body>
<form method="POST">
<input type="text" name="name">
<br>
<input type="text" name="email">
<br>
<input type="text" name="mobile">
<br>
<button name="submit">Submit form</button>
</form>
</body>
</html>Thankyou.php Page
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Thank you</title>
</head>
<body>
Thank you
</body>
</html>