Prerequisites:

• A Mailgun account with API access
• A Google account with access to Google Sheets
• Basic knowledge of programming (preferably in Python for this guide)
• Google Cloud Project with the Sheets API enabled
• OAuth 2.0 setup for the Google Sheets API

1. Install Python on your system if it’s not already installed.
2. Install necessary Python libraries using pip:
   ‍pip install requests google-auth google-auth-oauthlib google-auth-httplib2 google-api-python-client

1. Log in to your Mailgun account.
2. Navigate to the API Security settings and note down your API key and the base URL for your Mailgun API.

1. Go to the Google Developers Console (https://console.developers.google.com/).
2. Create a new project or select an existing one.
3. Go to “API & Services” > “Credentials”.
4. Configure the OAuth consent screen.
5. Create credentials > OAuth client ID > select “Desktop app” as the application type.
6. Download the JSON file with your credentials and save it as credentials.json in your working directory.

1. Create a Python file (e.g., mailgun_to_sheets.py) and import the necessary modules:
   ‍import requests
import json

2. Write a function to fetch data from Mailgun:
   ‍def fetch_mailgun_data(api_key, domain):
   url = f"https://api.mailgun.net/v3/{domain}/events"
   auth = ("api", api_key)
   response = requests.get(url, auth=auth)
   if response.status_code == 200:
       return response.json()
   else:
       raise Exception("Failed to fetch data from Mailgun")

1. Continue in the same Python file and import Google Sheets API modules:
   ‍from google.oauth2.credentials import Credentials
from google_auth_oauthlib.flow import InstalledAppFlow
from google.auth.transport.requests import Request
from googleapiclient.discovery import build

2. Write a function to authenticate and get access to Google Sheets:
   ‍SCOPES = ['https://www.googleapis.com/auth/spreadsheets']

def google_sheets_auth():
   creds = None
   if os.path.exists('token.json'):
       creds = Credentials.from_authorized_user_file('token.json', SCOPES)
   if not creds or not creds.valid:
       if creds and creds.expired and creds.refresh_token:
           creds.refresh(Request())
       else:
           flow = InstalledAppFlow.from_client_secrets_file('credentials.json', SCOPES)
           creds = flow.run_local_server(port=0)
       with open('token.json', 'w') as token:
           token.write(creds.to_json())
   return creds

3. Write a function to insert data into Google Sheets:
   ‍def insert_data_to_sheets(creds, spreadsheet_id, range_name, data):
   service = build('sheets', 'v4', credentials=creds)
   sheet = service.spreadsheets()
   body = {
       'values': data
   }
   result = sheet.values().append(spreadsheetId=spreadsheet_id, range=range_name,
                                  valueInputOption='USER_ENTERED', body=body).execute()
   print(f"{result.get('updates').get('updatedCells')} cells appended.")

1. In the same Python file, combine the above functions to fetch data from Mailgun and insert it into Google Sheets:
   ‍def main():
   # Mailgun credentials
   api_key = 'your_mailgun_api_key'
   domain = 'your_mailgun_domain'
   
   # Fetch data from Mailgun
   mailgun_data = fetch_mailgun_data(api_key, domain)
   # Format the data as needed for Google Sheets
   formatted_data = [[entry['id'], entry['event'], entry['timestamp']] for entry in mailgun_data['items']]
   
   # Authenticate with Google
   creds = google_sheets_auth()
   # Google Sheets details
   spreadsheet_id = 'your_spreadsheet_id'
   range_name = 'Sheet1'  # Or any other sheet and cell range where you want to insert data
   
   # Insert data into Google Sheets
   insert_data_to_sheets(creds, spreadsheet_id, range_name, formatted_data)

if __name__ == '__main__':
   main()

2. Replace 'your_mailgun_api_key', 'your_mailgun_domain', and 'your_spreadsheet_id' with your actual Mailgun API key, domain, and Google Sheets spreadsheet ID.
3. Run the script:python mailgun_to_sheets.py


This script will prompt you to authenticate with Google the first time you run it, and it will store the credentials for future use. Once authenticated, it will fetch the data from Mailgun and append it to the specified Google Sheet.