能否通过API创建Google Sheet并存储至DigitalOcean Space存储桶？

Absolutely, this is completely doable! You just need to chain together two APIs: the Google Sheets/Drive API to create and export your sheet, then DigitalOcean Spaces' S3-compatible API to upload the exported file to your bucket. Here's a step-by-step breakdown:

Step 1: Create your Google Sheet as normal #

You already know how to do this via the Google Sheets API. Just make sure you capture the sheet ID after creation—you'll need it for the next step.

Step 2: Export the Google Sheet to a standard file format #

Google Sheets are stored as a native Google format, so you can't directly upload them to Spaces. Instead, use the Google Drive API to export the sheet to a file type like CSV, XLSX, or PDF.

For example, using a Python snippet with the Google Drive API:

from googleapiclient.discovery import build
from google.oauth2 import service_account

# Initialize Drive API client
creds = service_account.Credentials.from_service_account_file('your-service-account-key.json')
drive_service = build('drive', 'v3', credentials=creds)

# Export sheet as XLSX
sheet_id = 'your-sheet-id-here'
request = drive_service.files().export_media(fileId=sheet_id, mimeType='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
exported_file = request.execute()

# Save the exported content to a local temp file (or stream it directly to Spaces)
with open('exported-sheet.xlsx', 'wb') as f:
    f.write(exported_file)

Common MIME types for export:

• CSV: text/csv
• XLSX: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
• PDF: application/pdf

Step 3: Upload the exported file to DigitalOcean Spaces #

Since DigitalOcean Spaces is S3-compatible, you can use AWS SDKs (like boto3 for Python) with DO's endpoint. Here's a quick example to upload the file:

import boto3

# Initialize Spaces client
spaces_client = boto3.client('s3',
    region_name='nyc3', # Replace with your Spaces region
    endpoint_url='https://nyc3.digitaloceanspaces.com',
    aws_access_key_id='your-do-access-key',
    aws_secret_access_key='your-do-secret-key'
)

# Upload the file to your bucket
spaces_client.upload_file('exported-sheet.xlsx', 'your-bucket-name', 'path/in/bucket/exported-sheet.xlsx')

Pro tip: You can stream the exported content directly to Spaces without saving it to a local file to save disk space—just pass the bytes stream instead of a file path.

Key Considerations #

• Permissions: Ensure your Google service account has the https://www.googleapis.com/auth/drive scope (or a more restricted scope if possible) to export the sheet. For DigitalOcean, generate an access key with write permissions to your target bucket.
• Cleanup: If you don't need to keep the sheet in Google Drive, you can delete it via the Drive API after successful upload to Spaces.
• Error Handling: Add try/except blocks to handle cases where export or upload fails (e.g., network issues, permission errors).

内容的提问来源于stack exchange，提问作者Townheadbluesboy