Get data from a row

  1. Head over to “Gears” in the top-right corner of your GearPlug App.

  1. Pick Google Spread Sheets as your source app and click “Create.”

  1. Click the red gear next to the app’s name. This will show the existing connections. Pick the one you want to use and click “Continue.” If you haven’t created a Plug for the account you want to use, you may do it under “Create a new connection.”

GearPlug will check whether the connection functions properly before moving on. If it doesn’t, you won’t be able to continue setting up your Gear.

  1. Pick “Get data from a row” in the drop-down menu and click the red gear. Pick the spread sheet and worksheet you wish to use. Then, Click “Create.”

  1. Create a test entry in your sheet, filling in all the fields (columns) you need, when the pop-up window asking for a new record appears. This will execute the connection’s trigger: a new entry.

Create an entry in Google Spread Sheets: GearPlug needs a new record to test whether it can extract the data successfully. After this record, all future entries will be registered automatically.

  1. Review the imported record to verify everything works properly. If you’re satisfied, click “OK.”

Empty fields: Under the imported record, you’ll find a drop-down list of “Empty Fields.” There, you’ll find fields you can import—but weren’t used in the contact form.

Done! Your source Plug is ready, and GearPlug will save all new records after this one. You may now set up your target Plugs.

Last updated