步骤1：创建安全组 首先，需要在AWS控制台上创建一个安全组。可以在安全组中添加需要允许的入站规则。

步骤2：获取安全组ID 获取创建的安全组的安全组ID。可以在AWS控制台中或使用AWS CLI命令获取。

步骤3：编写Google Apps Script代码 以下是Google Apps Script代码示例。在此示例中，将Google Apps Script IP地址添加到AWS安全组中。

function updateAwsSecurityGroup(){ var url = "https://ipinfo.io/ip"; var response = UrlFetchApp.fetch(url); var ip = response.getContentText(); var awsUrl = "https://ec2.amazonaws.com/"; var groupName = "group-name"; // AWS安全组的名称 var awsRegion = "us-west-2"; // AWS区域 var securityGroupId = "sg-123456"; // AWS安全组ID

var payload = "" + securityGroupId + "tcp065535" + ip + "/32";

var signatureVersion = "2"; var signatureMethod = "HmacSHA256"; var timestamp = new Date().toISOString(); var accessKey = "YOUR_ACCESS_KEY"; // AWS访问密钥 var secretKey = "YOUR_SECRET_KEY"; // AWS秘密密钥

var parameters = { "AWSAccessKeyId": accessKey, "Action": "AuthorizeSecurityGroupIngress", "GroupId": securityGroupId, "IpProtocol": "tcp", "FromPort": "0", "ToPort": "65535", "CidrIp": ip + "/32", "SignatureVersion": signatureVersion, "SignatureMethod": signatureMethod, "Timestamp": timestamp };

var sortedParams = parameterSort(parameters); var stringToSign = getQueryString(sortedParams, awsUrl); var signature = sign(stringToSign, secretKey);

var finalUrl = awsUrl + "?AWSAccessKeyId=" + accessKey + "&Action=AuthorizeSecurityGroupIngress