Description
This PR adds Google Sheets integration for logging offline conversions
A sendConversionToAPI function was implemented to handle basic conversion data (GCLID, name, value, currency, and timestamp). It adjusts the timestamp (+2h) . A Vitest integration test was also added, running in a Node environment, this checks everything works as expected .
Related Issues
Related Pull Requests
Checklist
- Changes have been tested locally.
- Unit tests have been written or updated as necessary.
- The code adheres to the repository's coding standards.
- Relevant documentation has been added or updated.
- No new warnings or errors have been introduced.
- SonarCloud issues have been reviewed and addressed.
- QA Passed
- Added env variables to production env ⚠️ IMPORTANT BEFORE MERGE ⚠️
Testing Process
We wrote a test using Vitest that simulates a conversion and calls our sendConversionToAPI function. We ran the test using npx vitest run, and upon checking the Google Sheet, we confirmed the data had been successfully appended. This verified the integration end-to-end.
Additional Notes
Expected Release: As soon as posible