Using Google App Scripts to connect with Amazon S3

Question

I have a Google Sheets add-on which let users get stock price in Google Sheets. I am trying to copy users' request in the spreadsheet to S3. I am using the same library as in this question on Stackoverflow and I encounter the exact same error:

AWS Error - SignatureDoesNotMatch: The request signature we calculated does not match the signature you provided. Check your key and signing method

Just wondering whether anyone has experience with this? The solution in that question does not work for me

````
AWS Error - SignatureDoesNotMatch: The request signature we calculated does not match the signature you provided. Check your key and signing method
````

Just wondering whether anyone has experience with this? The solution in that question does not work for me

Answer

Hey,

When you use AWS services such as S3, your request is authenticated using an algorithm called SigV4. This should be done automatically by the library you're using (in your case [S3-for-Google-Apps-Script](https://github.com/eschultink/S3-for-Google-Apps-Script)) but this error message suggests that this process has been done incorrectly.

This is most likely an issue with the library you are using and so you'll probably have the most luck if you reach out to the authors e.g. by [creating an issue on their GitHub page](https://github.com/eschultink/S3-for-Google-Apps-Script/issues/new).

However, I've had a quick look through their code and it looks like their [SigV4 code is hard-coded to use the AWS us-east-1 region](https://github.com/eschultink/S3-for-Google-Apps-Script/blob/master/S3Request.gs) Therefore, you may find it works if you try using an S3 bucket located in us-east-1 (N. Virginia)

Thanks,

Marrick.

Using Google App Scripts to connect with Amazon S3

相關內容