Calling Google App Script from PHP using curl?

Question

I am trying to call my Google App from a PHP Script, this is the code:

$ch = curl_init();
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_URL, "https://script.google.com/macros/s/.../exec");
$res = curl_exec($ch); // $res = true

This calls the URL and the "Loading" screen from Google App Script is shown and thats it, nothing else happens. Calling the URL from the browser works, so it must be related to curl. Maybe I have to set another curl option?

Thanks!

AHeraldOfTheNewAge · Accepted Answer · 2021-06-09 07:11:31Z

1

Here is an example for calling google apps script with a POST request

// set some post fields
$post = [
    'username' => 'user1',
    'password' => 'passuser1',
    'gender'   => 1,
];

$url = curl_init('https://script.google.com/macros/s/... your apps script url basically .../exec');
curl_setopt($url, CURLOPT_RETURNTRANSFER, true);
curl_setopt($url, CURLOPT_POSTFIELDS, $post);
curl_setopt($url, CURLOPT_FOLLOWLOCATION, true); //we must follow location -> google apps script makes a small redirect "for security reasons"

// execute!
$response = curl_exec($url);

// close the connection, release resources used
curl_close($url);

// do anything you want with your response
var_dump($response);

answered Jun 9, 2021 at 7:11

AHeraldOfTheNewAge

575 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jj-lucas · Accepted Answer · 2014-12-21 11:33:13Z

0

This snippet below has worked wonders for me in the past:

$APPS_SCRIPT_URL = 'https://script.google.com/macros/s/.../exec';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $APPS_SCRIPT_URL); 
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'GET');
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
curl_setopt($ch, CURLOPT_TIMEOUT, 20);
$content = trim(curl_exec($ch));
curl_close($ch);

Also, remember to properly authorize and publish your script for it to be executed by an anonymous user (your PHP script)

answered Dec 21, 2014 at 11:33

jj-lucas

1431 gold badge1 silver badge13 bronze badges

1 Comment

user1788736 Over a year ago

Is it possible to get the google script response back to php without getting 302 error?

Collectives™ on Stack Overflow

Calling Google App Script from PHP using curl?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related