With Sheetgo, you can integrate your Razorpay account directly into Google Sheets to automatically import payment, order, and customer data. This integration eliminates manual CSV exports, keeping your financial records, dashboards, and analytics updated in real time. Automating Razorpay data into Sheets enables your finance and operations teams to track transactions, revenue trends, and settlements with complete accuracy.
Prerequisites
- A verified Razorpay account with API access.
- Your Razorpay API Key ID and Key Secret.
- Access to the Razorpay API documentation: https://razorpay.com/docs/api/.
- A Sheetgo account linked to your Google Workspace.
Step 1: Identify the Required API Endpoint
Visit the Razorpay API documentation (linked above) and locate the GET endpoint for the data you want to import. The most common endpoint for retrieving payments is: https://api.razorpay.com/v1/payments. This endpoint returns payment details such as amount, currency, method, status, and customer email, which are ideal for real-time transaction tracking.
Step 2: Generate API Credentials
Log in to your Razorpay Dashboard and go to Settings → API Keys. Click Generate Key to create a new Key ID and Key Secret. Copy both values and store them securely — these will be required for authentication. Razorpay uses Basic Authentication, where credentials are encoded in Base64 as Key_ID:Key_Secret.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
Open Sheetgo, create a new workflow, and select HTTP Request as your data source. Enter the endpoint you selected earlier: https://api.razorpay.com/v1/payments. Then, paste the following header JSON configuration in Sheetgo:
{
"Authorization": "Basic YOUR_BASE64_ENCODED_KEYID_KEYSECRET",
"Content-Type": "application/json",
"@pagination": {
"type": "cursor",
"cursor_param": "skip",
"limit_param": "count"
}
}This setup uses Basic Authentication (encoded credentials) and applies cursor-based pagination using Razorpay’s skip and count parameters, ensuring Sheetgo retrieves all payment data automatically.
Step 5: Choose the Destination Spreadsheet
Select or create a Google Sheet where Razorpay data will be imported. Map columns such as id, amount, status, email, and created_at to ensure consistent formatting. Configure the Sheetgo workflow to append or overwrite data as needed during updates.
Step 6: Execute the Sheetgo Connection
Click Run to execute the workflow. Sheetgo will send a GET request to Razorpay and import the payment data into your selected spreadsheet. After successful execution, set up automatic refreshes (hourly, daily, or weekly) to keep your Razorpay data synced for up-to-date financial dashboards and reporting.