Overview
The node named "SmartProxy" is designed to interact with the SmartProxy API, enabling users to perform various operations related to sheets. Specifically, for the "Add Row" operation under the default resource, it allows adding a new row of data to a specified sheet. This functionality is useful in scenarios where you want to programmatically append data entries to a spreadsheet-like structure managed by the SmartProxy service.
Practical examples include:
- Automatically logging form submissions into a SmartProxy sheet.
- Appending transaction records or event logs to a centralized sheet.
- Integrating data from other systems by adding rows dynamically.
Properties
| Name | Meaning |
|---|---|
| Sheet ID | The unique identifier of the sheet where the new row will be added. |
| Values | A JSON object representing the data values for the new row to be inserted into the sheet. |
Output
The node outputs JSON data representing the result of the add row operation. This typically includes confirmation details such as the newly added row's data or metadata returned by the SmartProxy API. There is no indication that the node outputs binary data.
Dependencies
- Requires an API key credential for authenticating with the SmartProxy API.
- The base URL for the SmartProxy API must be configured in the node credentials.
- The node sends requests with
Accept: application/jsonandContent-Type: application/jsonheaders.
Troubleshooting
- Common issues:
- Invalid or missing Sheet ID can cause the operation to fail.
- Incorrectly formatted JSON in the "Values" property may lead to request errors.
- Authentication failures if the API key or base URL is not properly set.
- Error messages:
- Errors related to authorization usually indicate problems with the API key or credential setup.
- Validation errors from the API might indicate missing required fields or invalid data types in the "Values" JSON.
- Resolutions:
- Verify the Sheet ID exists and is accessible.
- Ensure the JSON structure in "Values" matches the expected schema of the target sheet.
- Confirm that the API key credential and base URL are correctly configured in n8n.
Links and References
- SmartProxy API Documentation (example placeholder link; replace with actual documentation)
- n8n documentation on creating custom nodes