Skip to content

Latest commit

 

History

History
55 lines (41 loc) · 2.41 KB

README.md

File metadata and controls

55 lines (41 loc) · 2.41 KB
Raw

Paiza Connector

Paiza Connector is a Google Apps Script designed to automate data submission to a specified endpoint by extracting information from a Google Spreadsheet. This script fetches data from specified cells, structures it into a form submission, and logs the submission time both within the spreadsheet and on a dedicated logging sheet.

Features

  • Data Extraction: Automatically retrieves data from a Google Spreadsheet.
  • Automated Submissions: Submits data to a specified endpoint using HTTP POST requests.
  • Logging: Logs each submission time in the spreadsheet and a separate logging sheet for tracking and audit purposes.

Prerequisites

Before you begin, make sure you have:

  • A Google account with access to Google Drive and Google Sheets.
  • Access to Google Apps Script.
  • A target endpoint URL where data will be submitted.
  • Required authentication tokens and any other necessary data for the form submission.

Setup

  1. Open Google Sheets:

    • Open or create a new Google Spreadsheet.
    • Name your worksheet appropriately as per your needs (e.g., 'アドレス帳1').

  2. Open Google Apps Script:

    • Go to Extensions > Apps Script.
    • Copy and paste the code from this repository into the script editor.
    • Replace placeholder values like YOUR_AUTH_TOKEN, YOUR_COUPON_CODE, and the url with actual data relevant to your configuration.

  3. Configure the Script:

    • Ensure the sheet names and cell ranges in the script match those in your spreadsheet.
    • Adjust the logging mechanisms if different behavior is desired.

Deployment

  1. Save and Name Your Project:

    • Click on the floppy disk icon to save your project.
    • Name your project (e.g., 'paiza-connector').

  2. Deploy the Script:

    • Click on 'Deploy' > 'New deployment'.
    • Choose 'Select type' > 'Web app'.
    • Set 'Execute as' to your account.
    • Set 'Who has access' to 'Anyone with Google account' or as per your security requirements.
    • Click 'Deploy' and authorize the script if prompted.

  3. Set Triggers (Optional):

    • If you need the script to run automatically at set intervals, set up a time-driven trigger.
    • Go to Triggers > Add Trigger, select your function, and specify the trigger type and frequency.

Usage

To manually execute the function:

  • Open the Apps Script project.
  • Select the function submitFormData in the drop-down menu.
  • Click on the play button to run the function.